Calculation in a pivottable

[GerardVDL1968]

Hi,

I tried my best to make a calculation in a pivottable but I cant get it done.

What I want is to ad a extra field at the end of the pivottable containing this formula : =Yes/(total-Vac) to get a result of 33%. 

How to get this done?

Gerard

[#2]

@GerardVDL1968 You need to do that in Power Pivot and create some DAX measures. See attached file containing a working example.