I'd like to have a pivot table which its values are based on the %difference from the column total.
In the attached file for example, I manually created table 2 based on table 1 base, but I'd like to create table 2 using pivot. you can see for example that cell C21 (colored in yellow) is calculated by C5/C12.
I tried using for this one in pivot option "show values as ->%difference from", but it didn't work for me.
Can anyone please assist?
Thank you very much,