Calculation

[rido1421]

Hi There

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

regards

[Anil_Babu_Samineni · Accepted solution]

May be try this?

=FirstSortedValue([Income Class], -Aggr(Sum([No of Households]), Suburb, [Income Class]))

[rido1421]

Thanks you works perfectly