Calculation in a pivottable

Occasional Visitor


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?



1 Reply

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