Mar 29 2023 01:05 AM
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
Mar 29 2023 05:24 AM
@GerardVDL1968 You need to do that in Power Pivot and create some DAX measures. See attached file containing a working example.