Calculate percentage between to column values in pivot table

[mejiaks]

Hi guys

I have a pivot table

Year and Week are Rows

Orders and Return Loaded are calculations based on sum(OrderSum) and sum(Reutilized) respectively

what I need is a third calculation based on the division of Return Loaded and Orders

This is to show what % Reutilized represent of the total orders

in the first case would be 14.04% (8 represent 14% of 57

I have tried calculated field, show value as but so far no success

I need this to create a graph with two axis

tnx in advance

 

[mejiaks]

I already found a solution myself I used a measure in power pivot and that worked perfectly