This is a new feature introduced in Excel 2013. This feature is used to filter data that was filled in our sheet. This feature filters the data of the Pivot Table. We can filter the data based on the years, day, month or quarters using the timeline feature. We can filter the Pivot Table data through this new feature of Excel 2013.
Let's have a look at the following steps.
Go to Excel 2013.
Now select the blank workbook templates from the available templates.
Now first fill the sheet with the following data.
Now first we will make a Pivot Table and to do this just select the insert menu option like this:
And under it just select the Pivot Table option like this:
Now A create Pivot Table dialog box will appear like this and in it just select the existing Worksheet option like this:
Now select some range of the Excel sheet where we want to show the data in the form of a Pivot Table and click on the ok button:
Now select the checkboxes indicating the Pivot Table Fields like this:
A Pivot Table will appear like this:
Now to filter the data in the Pivot Table according to the timelines just again select the insert menu option like this:
Now click on the Timelines option like this:
An Insert Timelines dialog box will appear and in it just select the Delivery Date check box and click on the ok button like this:
A Delivery Date Time Line will appear according to the month like this:
If in this we will select the September and August month then in the Pivot Table my data will be filtered according to the September and August month.
If we want to filter the data according to the days in the timeline then we will select the days option from the following DropDownList:
Now the days TimeLine will appear like this:
Now in this if we will select some set of days then the data which lies within these in the Pivot Table will be filtered like this: