Calculate pivot table items in 2007
 

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

Calculate pivot table items in 2007
 

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

And this:
http://office.microsoft.com/en-us/ex...091071033.aspx

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


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dianeg" wrote:

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

Calculate pivot table items in 2007
 

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

"ryguy7272" wrote:

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

And this:
http://office.microsoft.com/en-us/ex...091071033.aspx

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


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dianeg" wrote:

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