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"
DATA("Sum of Standard";$A$3;"Category";
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?