cancel
Showing results for
Did you mean:
Creator III

## Calculation

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

1 Solution

Accepted Solutions

May be try this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
2 Replies

May be try this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator III
Author

Thanks you works perfectly

Community Browser