Hide/Remove totals on Rows in Pivot table

[Adam]

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

 

[tina]

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

 

[Debra Dalgleish]

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