Using the timeline filter with pivot tables
In this recipe, you will create a new timeline filter that enables users to quickly choose the time frame that they want to analyze. The timeline filter is easier to use than having to select rows from the pivot table fields.
How to do it...
Open Excel and connect to the Crash_Data_SSASTM model and create a new pivot table report.
Add WEATHER_CONDITION to columns, from the MasterCalendar_T select YQMD, and finally add Count_of_Crashes to the values.
Select the Insert menu and then in the filter area select Timeline.
On the Insert Timelines windows, select the MasterCalendar_T table and click OK.
A new filter window will be added to your worksheet. Change the dropdown on the right to Years from Months to see all available years. You change your filter criteria by selecting the different hierarchy of the YQMD to change what the slicer shows.
To interact with the data, select the years that you want to focus your analysis on. Select 2010 to see only...
