"Cumulative" column based on a pivot table sum column?

[Guest]

I'm trying to create a rollup column based on a pivot table data column. The
GETPIVOTDATA function includes static field and index ("item") references,
and so can't be copied (the copies reference the original pivot field/item
pair). Is there a better way to create a cumulative column than building it
cell-by-cell? I'm using Excel 2003. Thanks -

 

[Guest]

You can turn off the GETPIVOTDATA function, but for a quick fix...
don't point to the cell reference.
Instead, type in the reference to the pivot table.

For example, if the Pivot Table row totals are in Cells C2:c20, then
D20:=SUM($C$20:C20)

copy that formula down as far as you need.

Note: To disable the GETPIVOTDATA function...see Debra Dalgleish's site:
http://www.contextures.com/xlPivot06.html

Does that help?

***********
Regards,
Ron

 

[Guest]

D'oh! Thanks, Ron-

You can turn off the GETPIVOTDATA function, but for a quick fix...
don't point to the cell reference.
Instead, type in the reference to the pivot table.

For example, if the Pivot Table row totals are in Cells C2:c20, then
D20:=SUM($C$20:C20)

copy that formula down as far as you need.

Note: To disable the GETPIVOTDATA function...see Debra Dalgleish's site:
http://www.contextures.com/xlPivot06.html

Does that help?

***********
Regards,
Ron