Calculate pivot table items in 2007

[Dianeg]

I have created a sum using getpivotdata to add 2 items in a pivot table. The
first one works fine but when I try to copy it down the column, I get the
same answer. I've removed any absolutes. Have you any clues as to why this
is happening?

Any thoughts gratefully received

Regards

Diane

 

[ryguy7272]

Try the getpivotdata function! See this:
http://www.contextures.com/xlPivot06.html

And this:
http://office.microsoft.com/en-us/excel/HP052091071033.aspx

And this:
http://support.microsoft.com/default.aspx/kb/287736

 

[Dianeg]

Thanks very much, I'll give them a go tomorrow!

Try the getpivotdata function! See this:
http://www.contextures.com/xlPivot06.html

And this:
http://office.microsoft.com/en-us/excel/HP052091071033.aspx

And this:
http://support.microsoft.com/default.aspx/kb/287736