Forum Discussion
GerardVDL1968
Mar 29, 2023Copper Contributor
Calculation in a pivottable
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
- Riny_van_EekelenPlatinum Contributor
GerardVDL1968 You need to do that in Power Pivot and create some DAX measures. See attached file containing a working example.