Practice Exercise 21: Create a timeline to filter a pivot table.
FIGURE 1 – Pivot table Analyze tab toolbar
Still use data file, RANGE TO TABLE TO PIVOT TABLE2.
STEP 1: Select any pivot table cell. Select the Analyze tab from the Ribbon PivotTable Tools as shown in FIGURE 1.
STEP 7: The timeline is currently selected for Jan-Mar 2014. The filter icon up at the top right corner of the timeline illustrates that filtering is currently being used. The filter can be cleared with the mouse just like a regular slicer (FIGURE 7).
STEP 8: Click on the timeline and the Timeline tab will appear. Click on the Timeline tab and you will see the Timeline toolbar appear, as shown below in FIGURE 8.
STEP 9: In the Timeline section of the Timeline Tools, to change the Timeline Caption from “Date” to something else (i.e. “Period”), click mouse inside the Timeline Caption window and enter the new name.
Click mouse inside the Timeline Caption window and replace “SalesDate” (FIGURE 9) with “Date of Sale” (FIGURE 10).
This is the end of this section. To continue, go to Module 4 Section 4.3 Create a Pivot Table Chart; Practice Exercise 22