Antonio, Use table calculations Window_Sum or Window_Avg, I hope that will work!
It's hard to conceptualize this... can we get a screenshot?
Off the top of my head, I would say that something like:
SUM([Leavers]) / AVG([Headcount])
would work. If this is not the case, it's likely you need to leverage table calculations... some combination of WINDOW_SUM, WINDOW_AVG, SUM, and AVG should do the trick.
hi there - any other suggestions?
i managed to solved it
- created a Set with just the value I needed from the dimension [account_name]
- put that set on a table
- applied the following table calculation: (ZN(SUM([Actual + QRF])) / LOOKUP(ZN(SUM([Actual + QRF])), LAST()))*-1
The -1 is because I have my leavers numbers as negative and I wanted to reverse that for the bar chart display.