the formular i wrote is not working

Hi Ireneh,

Please share a screenshot so i can take a look. Thanks!

when I paste this formular =GETPIVOTDATA("Sum of "&$B4,Pivot!$A$3,"Years",C$2)/1000 in the other cells it showing

#REF!

I copied 2015 and 2016 direct from the Pivot table

Hi Ireneh,

Please check if 'Gross Sales Income' is written in the same way in the pivot table and in your output table.

Best,

Ned