Pivot Tables - Custom Calculations with Total

[m_brasse]

Hi everybody,
I am looking for help on a seemingly simple problem:

Pivot Table which contains the following fields:
Project/ Cost Type/ Item in Row
Month in Column
"Budget in this month", "Cost in this month" and "Accumulated Costs so far" in Data

Now I would like to show a field "Usage of Budget so far" in percent (e.g. burn rate).
I imagine something like a custom calculation which says: "Accumulated Costs so far"/SUM(all Budget entries in the row).

I played around with the field properties etc. and didn't find a solution.

Can you help me there?

I found many good tips on this site, so I hope, that this problem can be solved as well.

Thanks and best regards
Micha

 

[Andrew Poulsom]

I think you will need to add Budget for the year to your pivot table (from your source data).