Pivot tables - how to hide the total row?
 

I setup a pivot table programmatic.

But how can I hide the most right total row?
I have found a checkbox "Totals for rows / columns" in the TableOptions
Dialog.
But how to set this per programm?

Many thanks for any hint.
Wolfgang

Pivot tables - how to hide the total row?
 

On Jan 16, 5:34*pm, "Wolfgang Gary" wrote:
I setup a pivot table programmatic.

But how can I hide the most right total row?
I have found a checkbox "Totals for rows / columns" in the TableOptions
Dialog.
But how to set this per programm?

Many thanks for any hint.
Wolfgang

are you talking about the "Grand totals for rows" and "Grand totals
for columns" checkboxes in the pivot table options? if so, the code
would be:

'change "PivotTable1" to the correct Pivot Table name(s)
With ActiveSheet.PivotTables("PivotTable1")
.ColumnGrand = False
.RowGrand = False
End With

Pivot tables - how to hide the total row?
 

Yes - thanks for your Tipp.

I have only the German version installed so I dont know the exactly wording
in the English version.

Where / how to find all the "hidden" properties/methodes? Is there any good
book explaining the miracle of pivoting with excel?

many thanks & best regards
Wolfgang

Pivot tables - how to hide the total row?
 

On Jan 17, 1:36*am, "Wolfgang Gary" wrote:
Yes - thanks for your Tipp.

I have only the German version installed so I dont know the exactly wording
in the English version.

Where / how to find all the "hidden" properties/methodes? Is there any good
book explaining the miracle of pivoting with excel?

many thanks & best regards
Wolfgang

I'm not sure which books would be good. but you might want to check
out one of the pivot table book at www.contextures.com and also check
out their pivot table tips here http://contextures.com/tiptech.html