Filtering cross tab data : Creating a filter : Displaying data for relative time periods
 
Displaying data for relative time periods
You can select a relative time period to use as a data filter. If you specify a reference date, Data Analyzer can perform calculations based on the following relative time periods:
*Month to date
*Month to date last year
*Quarter to date
*Quarter to date last year
*Year to date
*Year to date last year
For example, if the reference date is March 4, 2011, the relative time period, year‑to‑date last year, is January 1, 2010 to March 4, 2010.
Figure 5‑17 shows the relative time period options for a date item.
Figure 5‑17 Viewing relative time period options
Data Analyzer provides a calendar you can use to select a date. Figure 5‑18 shows how to access the calendar and select a date.
Figure 5‑18 Using the calendar to select a date