Calculations from a PIVOT table

Hi
Trying to copy a Mix calculation down next to a pivot table which references data in the Pivot table itself
The problem is I'm having the same value returned as I copy down as though the cell reference is not changing :

=GETPIVOTDATA("Sum of STK UNITS",$A$5,"DESCRIPTION","MC Artesa 3pc Serving Domes 37x12cm - Slate-Glass-Wood","CATEGORY","Artesą","SRP",34.99,"MONTH",DATE(2017,3,1))/GETPIVOTDATA("Sum of STK UNITS",$A$5)

Is there a way of referencing data in the pivot as I would term " normally" as opposed to what looks like a very complex calculation specific to one reference ?

thanks

Without seeing your file, it is difficult to help, other than to make a general comment!

You appear to have built your GETPIVOTDATA formula by clicking on a cell in the PivotTable.

You need to change the formula so that when you're copying the formula down, it looks in the row you're adjacent to, and gets the value you want. I don't know what varies as you copy down, but suppose it is CATEGORY. Instead of having "Artesą" as the argument, put in the cell reference.

Try playing with it - if you can't work it out, post a sample worksheet, and I'll show you how.
I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".