count expression i need in dimension but doesnt work

[qliklizzy]

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

[rubenmarin · Accepted solution]

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.

[qliklizzy]

Thanks worked a treat!!!😉