Pivot Table Calculated field based on value of 1 (fixed) cell

[david_cc]

Hi guys,

I have an Pivot Table where I calculated a cumulative budget (last column) based on the column before (total budget) The first part of the overview has been deleted and the numbers have been changed. This view is based on everything. In this case all campaigns.

So far this works fine. Now I added some sliders to filter for specific campaigns. This also works fine but the cumulative budget (last column) now shows me the % of filtered campaigns and not the % of total spending.

Is there a way to do this? I have been playing around and created one cell on top of the Pivot Table with the sum of total spending. When I create a calculated field and refer to that cell it shows me an error message. Probably because the cell is outside the Pivot.

Any help is welcome

[TABLE="width: 804"]
<tbody>[TR]
[TD]42[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]12.0 €[/TD]
[TD] 504.8 €[/TD]
[TD="align: right"]1.4%[/TD]
[/TR]
[TR]
[TD]98[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]15.5 €[/TD]
[TD] 1,519.3 €[/TD]
[TD="align: right"]4.2%[/TD]
[/TR]
[TR]
[TD]114[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]28.3 €[/TD]
[TD] 1,229.3 €[/TD]
[TD="align: right"]9.0%[/TD]
[/TR]
[TR]
[TD]154[/TD]
[TD="align: right"]154[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]21.0 €[/TD]
[TD] 1,232.4 €[/TD]
[TD="align: right"]9.0%[/TD]
[/TR]
[TR]
[TD]Gesamtergebnis[/TD]
[TD="align: right"]1370[/TD]
[TD="align: right"]4536[/TD]
[TD="align: right"]26.1 €[/TD]
[TD] 5,796.8 €[/TD]
[TD="align: right"]100.0%[/TD]
[/TR]
</tbody>[/TABLE]