Shortcut to add or remove a Subtotal within a Pivot Table
Modified on: Tue, Mar 24, 2020 at 4:52 PM
Short Cut to add or remove a Subtotal within a Pivot
- if you wish to remove Total line from the Object column
Click on the column heading that you wish to remove a subtotal. The
Field Settings option will display.
Automatic is selected, click on the None option to remove the subtotal
from the view.
Object column will display only one line of totals.
you wish to add the subtotal in a column, simply select the Automatic
option to show columns with subtotals.
Did you find it helpful?
Sorry we couldn't be helpful. Help us improve this article with your feedback.