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