Thread: Syntax for referencing totals of grouped data in a pivottable
View Single Post
  #1   Report Post  
mbpcon
 
Posts: n/a
Default 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?




Reply With QuoteReply With Quote