Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have this as an expression but because of it being a pivot its repeated in each group so I want it in the dimension instead to show alongside the month and day - is this possible as if I use it in dimension I get error. I tried using total but that just repeated the figure across the dates
=num(Count({<EdReadyKPI = {'Under'}>}EdReadyKPI)/Count(EdReadyKPI)*100, '#,#0%' )
thanks
Liz
Hi, try using aggr:
Aggr(num(Count({<EdReadyKPI = {'Under'}>}EdReadyKPI)/Count(EdReadyKPI)*100, '#,#0%' ), [Dim1, Dim2,...])
Change [Dim1, Dim2,...] for the current dimensions used in table.
Hi, try using aggr:
Aggr(num(Count({<EdReadyKPI = {'Under'}>}EdReadyKPI)/Count(EdReadyKPI)*100, '#,#0%' ), [Dim1, Dim2,...])
Change [Dim1, Dim2,...] for the current dimensions used in table.
Thanks worked a treat!!!😉