Microsoft Office Tutorials and References
In Depth Information
Referencing Cells within a Pivot Table
Figure 18-39: Using a slicer to filter a pivot table by state.
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-40 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.
Figure 18-40: The formulas in column F reference cells in the pivot table.
 
Search JabSto ::




Custom Search