I am trying to find the income class with the highest number of households in each suburb.
I would like to create an expression that will display the suburbs with the income class with highest no of households
I have tried it in the attached sample but its not working correctly if there are no selections, I want to display this for all suburbs
I have attached the data and qvw , please assist
May be try this?
=FirstSortedValue([Income Class], -Aggr(Sum([No of Households]), Suburb, [Income Class]))
View solution in original post
Thanks you works perfectly