Using set analysis to create a percentage

[gilldilpreet]

Hi, 

I have used the following set analysis as an expression to create the total FTE for a specific year against a dimension (e.g. gender) in a pivot table: sum({$<[ACYEAR]={"2018/19"}>}[FTE]).

I would now like to convert this number into a percentage i.e. total FTE of a gender for 2018/19 / total FTE for 2018/19 * 100. 

Can anyone help on this please? 🙂 

Many thanks

Dilpreet

[martinpohl · Accepted solution]

use

sum({$<[ACYEAR]={"2018/19"}>}[FTE])

/ sum({$<[ACYEAR]={"2018/19"}>}total [FTE]) *100

Regards