GetPivotData

D

dmcgimpsey

I have a formula that is a calculation from two fields in a pivo
table... for example:

=GETPIVOTDATA("Spend ($)",$A$10,"Event Description","Selected","Sourc
Code","E10","As of Date",DATE(2002,7,1))/GETPIVOTDATA("AIF Coun
",$A$10,"Event Description","Selected",

Now that it displays the result where I want it, I would like to cop
the formula across by dragging the anchor outline and copying th
relative cells across as I do. Instead, the copy function only paste
the value of the destination cell.

Can someone give me a method to do this please?

Thanks in advance

Do
 
D

Debra Dalgleish

Instead of using the pivot item names in the formula, enter them on the
worksheet, and refer to those cells in the GETPIVOTDATA formula. For
example, with code "E10" in cell B3, change the formula to:

=GETPIVOTDATA("Spend ($)",$A$10,"Event Description","Selected","Source
Code",B3,"As of Date",DATE(2002,7,1))/GETPIVOTDATA("AIF
Count",$A$10,"Event Description","Selected",

Enter the remaining codes in cell C3:G3, and drag the formula across
The formula result will change for each code.
 
Top