Add 2 Report Measures: Dept Active FTE and Vacancy Rate %
I have an Analysis that calculates vacancy rate by department. I need expert advice on how to add two measures to the pivot table. I want to add a measure "Dept Active FTE" (this is the total number of active FTE's in the dept) and add a calculated Vacancy Rate % measure. This calculation is: Open Work FTE / (Open Work FTE + Dept Active FTE) * 100.
I hope this is possible and thank you in advance for your assistance.
The catalog file is attached. The Excel output should look like this:
Version (include the version you are using, if applicable):