Hi,

I am trying to build a budget pivot table but there is a functionality which I don't know how to do

Here is the pivot table

Total Planned Q1 spent Q2 spent Q3 spent Q4spent
Project A
Project B
Project C
Project D
Total Total total planned Total Q1 Total Q2 Total Q3 Total Q4


That pivot table works but on the top of the total which is automatically calculated, below that line, I'd like to have the percentage spent vs Total planned. Ideally I'd like to have

e.g. 100% 25% 30% 75% 101%
Total Q1 + Q2 Total Q1+Q2+Q3 Total Q1+Q2+Q3+Q4

Is there a way I can do this?

Thanks in advance