| 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? |
| 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) | |||
Threaded Mode
