Chapter 35: Analyzing Data with Pivot Tables
733
FIGURE 35.21Using Slicers to filter a pivot table by state and by month.
Referencing Cells within a Pivot Table
After you create a pivot table, you may want to create a formula that references one or more cells
within a pivot table. Figure 35.22 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.On the CD
This workbook, named income and expenses.xlsx, is available on the companion CD-ROM. n
FIGURE 35.22The formulas in column F reference cells in the pivot table.