Pivot table - percentage between 2 columns Max

[tiger837]

Hi everyone !

I come for your help on Pivot tables.

So I have done a pivot table, which depicts the maximum of a value on a specific date, for several parameters. See image in this link: http://www.noelshack.com/2018-49-3-1543999976-capture.png

So I have the Max values for X and Y on everydays displayed in the pivot table. But when I create another column to calculate the percentage of X/Y (with the calculated field option), I have the wrong result.
It looks like excel is doing the percentage between all the values of a date and then do an average of them, instead of taking the Maximum value already displayed by the pivot table, and do the percentage.

Does anyone have a solution for this ?

Thanks

 

[tiger837]

No one has an idea ?