| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude data from summary totals when hidden | Excel Worksheet Functions | |||
| How can I calculate weekly totals of daily data in Excel | Excel Worksheet Functions | |||
| Exclude hidden data from summary totals | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
