Hide/Remove totals on Rows in Pivot table

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".
 
G

Guest

Hi
Try taking off grand totals for row and grand totals for columns in the
option section of pivot wizard
Tina
 

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 totals 3
Pivot Table Column Totals - XL2003 5
Pivot Table - 3
Grand Total for Rows not Working in a Pivot Table 1
Pivot Table - move Totals column 1
Grand Totals for Pivot Tables 4
Pivot Table % of Totals 2

Top