2007 Excel Pivot Tables - turn off subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is they a way of turning off the "Subtotals" in columns and rows from the
start of creating the pivot table? In my Excel the option is greyed out under
Pivot Table Options>Tables & Filters .

Currently the only way I can find too turn them of is individually as I add
the column or row to the pivot table.

Any assistance is greatly appreciated.
 
Select a cell in the PivotTable
On the Ribbon, in the Design tab of the PivotTable Tools, click on
Subtotals.
Choose Do Not Show Subtotals
 
You're welcome, and thanks for letting me know that it's fixed.
Merry Christmas!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format pivot subtotals 2
Pivot table subtotals 2
Pivot Table percentages 1
Pivot Table - 3
Question on the occupied field of the pivot table in excel spreadsheet 0
Count of Non-Zero pivot table entries 1
Pivot Table Formula Problem 1
Pivot Tables: Subtotal only certain columns? 6

Back
Top