Calculating % in Pivotable

[howard]

I have total overdue amounts in Col E on my Pivottable


I am trying to calculate the % per Item as a % of the total on Col E on the Pivotable, but it returns 0.00%

 =GETPIVOTDATA("Total Overdue ",$A$3,"Name","Sales")/SUM(OFFSET(E3,1,0,50000))

It would be appreciated if someone could kindly assist me

 

[oldbrewer]

have you looked at calculated fields ?

 

[howard]

Thanks for the reply. Only thought of this late this afternoon and used calculated fields which worked perfectly