What I have?
I have two dimensions(state and city) and a measure (glid). I want to find the count of glid since glid is a unique reference no.
I want to arrange my data such that for each state I get only the top 3 or n cities having the highest count of glids, and I want the rest of the cities to be clubbed under a separate category, say "others".
I have done my due research but since I am new to tableau, could not fathom it.
Please be more elaborate in answering. I am attaching an image for further help
I know it can be done by grouping but since there are too many states and cities, it would be very tedious, can you suggest something?