Pivot Table Timeline

Timelines are interactive filters that let you quickly filter by date. They make it quick and easy to see PivotTable data for only the time period you specify. They are similar to slicers in that you can insert them once and keep them with the PivotTable to update at will.

Insert a Timeline

Click any cell inside the PivotTable.
Click the Analyze tab on the ribbon.
Click the Insert Timeline button.
You can also insert a Timeline for PivotCharts and cube functions.

The Insert Timelines dialog box appears. It automatically detects the date fields used in the PivotTable and has them available for you to select from. Many times, there will only be one available field.
Select the date field you want to use for the timeline.
Click OK.
Select a time span in the Timeline you want the PivotTable to display.

To select multiple intervals, you can click and drag along the timeline or click the first interval you want to include and hold the Shift key while clicking the last interval in your chosen span.