Show breakdown of dimension field as % instead of sum

[zakpullen]

Hi,

In the straight table below, I would like to display the answers as % for each band in the Grade column. For example, the total fte for Band 2 is 189.88 (don't need to see totals). Unspecified is 17. I would like to display that 17 as 8.95%. (can format the number ok).

I'm sure I've done something similar before, but can't figure it out.

Many thanks

[Kushal_Chawda · Accepted solution]

try below

=sum(FTE)/sum(TOTAL <Grade>FTE)

[zakpullen]

Perfect! Thank you Kush