Data Viz Done Right

September 29, 2015

Tableau Tip Tuesday: Sorting Dimensions with Lots of Members

I’ve been faced with this scenario many times - I need to sort the top N of a dimension by a measure (e.g., sales), but I want the rest of the members of the dimension to be sorted alphabetically. This is an especially handy trick if you have tons of members in your dimension. It makes it easy to see which members are in the top N, then the rest can be found by looking them up alphabetically.

This is a video tutorial that’s simpler than the method I outlined previously here. In this video, I use sets as recommended by commenters Nelson Davis and Joshua Milligan.

Watching the video, you may also pick up a few other tips along the way, like creating sets and parameters, quickly formatting worksheets, faking headers, etc.