Microsoft Office Tutorials and References
In Depth Information
After adding the total field to the PivotTable
total field rows
city of unpaid
grand total line
3. In the Show/Hide group on the Design tab, click the Hide Details button. Access
hides the detail lines and displays only the subtotal and grand total lines in the
PivotTable. See Figure 8-32.
Subtotals and grand total displayed in the PivotTable
4. In the Show/Hide group on the Design tab, click the Show Details button. Access
shows the detail lines and the subtotal and grand total lines in the PivotTable for
the cities of East Lansing, Lansing, and Rockford.
Sarah asks if you can display the filtered PivotTable data in a chart. You’ll switch to
PivotChart view to satisfy Sarah’s request.