Microsoft Office Tutorials and References
In Depth Information
After adding the total field to the PivotTable
Figure 8-31
AutoCalc button
total field rows
displaying
subtotals by
city of unpaid
and paid
invoices
city subtotals
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
Figure 8-32
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.
 
Search JabSto ::




Custom Search