Include or exclude hidden data when calculating totals

This procedure affects all subtotals and grand totals in the PivotTable list.

1. Click the title bar of the PivotTable list.
2. On the PivotTable list toolbar, click Commands and Options , and then click the Report tab.
3. Under Calculate totals based on, do one of the following:
   • To include hidden data, select All items (including hidden items).

   • To exclude hidden data, select Visible items only.

Notes  

• This setting affects data hidden by filtering row and column fields; data hidden by using filter fields is always excluded from totals.

• When you choose to include hidden data, asterisks (*) appear next to the captions of subtotals and grand totals to note that the total values include hidden items as well as displayed items.