Syntax for referencing totals of grouped data in a pivottable
 

I have a pivottable like the one shown beneath

Sum of Amount Account2 Account
G1 G1 Sum G2 G2 Sum G3 G3 Sum
Function A B AA BB
Marketing 10 10
Sales 10 40 50 200 200 1000 1000

I want to reference the grouped totals (G1 Sum, G2 Sum, G3 Sum) but I don't
seem to get the correct syntax for GETPIVOTDATA(syntax).

Can anyone help me?

Syntax for referencing totals of grouped data in a pivottable
 

If you're trying to get the totals for those columns, you should display
the Grand Totals for Columns. The arguments for GetPivotData will vary,
depending on the version of Excel that you're using.

mbpcon wrote:
I have a pivottable like the one shown beneath

Sum of Amount Account2 Account
G1 G1 Sum G2 G2 Sum G3 G3 Sum
Function A B AA BB
Marketing 10 10
Sales 10 40 50 200 200 1000 1000

I want to reference the grouped totals (G1 Sum, G2 Sum, G3 Sum) but I don't
seem to get the correct syntax for GETPIVOTDATA(syntax).

Can anyone help me?






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html