Microsoft Office Tutorials and References
In Depth Information
is updated immediately. To select a range of quarters, press Shift while you click the first and last buttons in the
range. Other filtering options (selectable 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.
A workbook that uses a timeline is available at this topic's website. The filename 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.
Figure 18-41: Using a timeline to filter a pivot table by date.
Referencing Cells within a Pivot Table
In some cases, you may want to create a formula that references one or more cells within a pivot table. Figure
18-42 shows a simple pivot table that displays income and expense information for three years. In this pivot
table, the Month field is hidden, so the pivot table shows the year totals.
Search JabSto ::

Custom Search