Pivot table: How to calculate new columns based on the pivot table itself?

[TheWes]

Hi all,

I am working with pivot tables which I had a questions about calculating new columns based on the pivot table itself.

Lets say my pivot table looks like this:

Name location	Revenue	FTE
Location	100	1,0

1) I want to calculate a column next to that based on these columns such as FTE costs (which would be FTE times a fixed amount) or gross profit (in this case revenue -/- fte costs).
2) my other solution is to post the output to a new sheet and start calculations from there. However I could minimize this by having it dynamic

Thanks alot.
best,
W

 

[TheWes]

desired output:

name location	Omzet	FTE indirecte medewerkers p/w	FTE costs
Aalsmeer, Legmeerdijk, Inh. Royal FloraHolland	100	1,0	1 * 80.000 = 80.000​
			​

The FTE costs column would be only created through a formula based on the pivot table itself.
Thank you all.

 

[TheWes]

Any suggestions? Thank you all.

 

[RoryA]

You can create calculated fields for that:

then:

for example.

You can then create another one that subtracts this field from the Revenue field.

 

[TheWes]

Thank you, above solutions works like a charm.
This also allows automatization whenever you want to refresh your pivot table whenever your source data has changed.