Welcome to the Financial Spreadsheets & Reporting Help Center

Find answers fast: Ask a question, search for keywords, or explore articles below.

Search

Shortcut to add or remove a Subtotal within a Pivot Table

Short Cut to add or remove a Subtotal within a Pivot Table

  1. Example - if you wish to remove Total line from the Object column





  1. Double Click on the column heading that you wish to remove a subtotal.   The Field Settings option will display.




  1. If Automatic is selected, click on the None option to remove the subtotal from the view.




  1. The Object column will display only one line of totals.



  1. If you wish to add the subtotal in a column, simply select the Automatic option to show columns with subtotals.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request