Filtering Pivot Tables with a TimelineA Timeline is conceptually similar to a Slicer, but this control is designed to simplify time based filtering in a pivot table. A Timeline is relevant only if your pivot table has a field that’s formatted as a date. This feature does not work with times. To add a Timeline, select a cell in a pivot table and choose Insert ➪ Filter ➪ Timeline. A dialog box appears listing all date-based fields. If your pivot table doesn’t have a field formatted as a date, Excel displays an error.Figure 34.22 shows a pivot table created from the data in columns A:E. This pivot table uses a Timeline, set to allow date filtering by quarters. Click a button that corresponds to the quarter you want to view, and the pivot table is updated immediately. To select arrange of quarters, press Shift while you click the buttons. Other filtering options (select table from the drop-down in the upper-right corner) are Year, Month, and Day. In the figure,the pivot table displays data from the first two quarters of 2012.FIGURE 34.22Using a Timeline to filter a pivot table by date. تصوير به ضميمه پيوست مي باشد. On the Web A workbook that uses a Timeline is available on this book’s website. The file name is pivot table timeline.xlsx.You can, of course, use both Slicers and a Timeline for a pivot table. A Timeline has the same type of formatting options as Slicers, so you can create an attractive interactive dashboard that simplifies pivot table filtering.
تایم لاین
کامنت