This is the best explanation of how to do the sub-category sort and top N I've found:
What you can do is create other calculation as below :
IF [Top N Sub Category Dim]='Others' THEN 'Others' ELSE 'Club' END
Put this calculation on the Rows.Then, uncheck the show header for this field.
This should have the desired result.
Attached is in newer version of Tableau, not sure if you would be able to open it.
Thanks Aseem it was really helpful
i am trying to calculate percentage of total but the values are all messed up, can you please help.
It won't work, because you doing count distinct.
When you do as percent of total, it looks for distinct customers across all catgories combined, rather than summing up distinct customers at individual category level.
You will have to create LOD for these purposes.