Hide/Remove totals on Rows in Pivot table

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

Guest

Hi All,

Is there a way I can remove the totals which in a pivot table?

I try right clicking on a total and selecting "Group and Outline" and "Hide
detail" however the error message "Cannot show or hide detail of this type".
 
Hi
Try taking off grand totals for row and grand totals for columns in the
option section of pivot wizard
Tina
 
You can hide the subtotals in a Pivot Table.

Double-click the field button, to open the PivotTable field dialog box
For Subtotals, select 'None'
Click OK

There are instructions here for doing this manually or programmatically:

http://www.contextures.com/xlPivot05.html
 
You must log in or register to reply here.

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

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table grand total location 1
Pivot Table - 3
Referencing a pivot tables Grand Totals Column 1
Surpressing rows and columns with zero values in a pivot table 1
Pivot Table - move Totals column 1
Grand Total for Rows not Working in a Pivot Table 1
Pivot Table Column Totals - XL2003 5

Back
Top