Percentage in pivot table

Hi All,


I am trying to calculate the percentage between previously calculated columns.

Excel.jpg


The first three columns are calcutated from a pivot table but I would like the percentage between Revenue and Margin --> IN the pivot table.
This s required so i do not have to change all calculations manually.

If you could help me thanks in advance

do you mean this ??
Book11.xlsx

How did you create the percentage INSIDE the pivot table?

(Nederlands) Ja dat bedoel ik. Alleen hoe krijg je een kolom van percentage ondanks dat deze niet in jouw stamdata staat?

goto pivotTable tools
click on button INSERT
choose INSERT CALCULATED FIELD
NAME: PERCENTAGE
FORMULA =('werkelijk open'\'marge open')\100

Change the format cells of the new column to percentage

done