Tuesday, March 27, 2012

How to Add a Subtotal to a Pivot Table


1. Select your items, row, or column that you would like to subtotal in your pivot table report.
2. Click 'Field Settings' in the 'Active Field' group on the 'Options' tab.
3. Click 'Automatic' under 'Subtotals' to subtotal the outer row or column label.
4. Select 'Custom' under 'Subtotals' to choose a function for an inner row or column label.

Blogger news