I have a dataset with customer count, age groups and suburbs. I'm trying to get top 5 suburbs with max customers within the age group. I used the filter option and then top 5 but for age group 0-5 i'm not getting the correct result.
I have attached the sample workbook.
To calculate TOP N within group, you can use Rank as table cal with re-staring.
rank(sum([No of Customers]))
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...