Syntax for referencing totals of grouped data in a pivottable

G

Guest

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?
 
D

Debra Dalgleish

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.
 

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

Summing multiple account #s in one cell, by referencing 4
Calculate totals for a range of names 10
show all data in a totals query 3
I need to Sum multiple columns by referencing one formula. 2
Referencing Data in a Pivot table. More Excel 2003 misery 1
I need to Sum multiple columns by referencing one formula 2
FS LARGE FORMAT scanners , INKJET printers , inkjet plotters (hp designjet) , 11x17 color laser $199 0
FS inkjet plotters AND continous feed 36 inch scanners 0

Top