Excel 2010 - Calculation from Pivot columns

Dear Experts,

Can you please have a look at the pivot in the attached file, in D5 there is a formula

=GETPIVOTDATA("Sum of Stock";$A$3;"Category";"A")-GETPIVOTDATA("Sum of Standard";$A$3;"Category";"A")

But somehow if I copy this formula down so to follow this logic also in cells D6-D7-D8, it writes everywhere the same value.

Can you please advise how the formula should be to be able to copy down?

thanks,
CalcFromPivotColumns.xlsx
LVL 1
csehzIT consultantAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

edit the formula in cell D5 to read

=GETPIVOTDATA("Sum of Stock",$A$3,"Category",A5)-GETPIVOTDATA("Sum of Standard",$A$3,"Category","A")

then copy down.

cheers, teylyn
0
 
csehzIT consultantAuthor Commented:
Thanks it is super like that
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.