Top M within each top N of categories
I recently helped with a Tableau community forums question where the user needed to: filter to the top N categories based on a measure, using a dense rank (so that categories with the same value had the same rank), but list no more than M categories within each rank (based on another criteria) This screenshot illustrates the requirement where we want to see the top 5 categories based on sales, where categories with the same sales have the same rank. But we only want to see the top 2 within each rank, based on lowest cost: ...