alright, so you want to see the list of your Top 100 customers
Top 100 Customers sorted based on “# of products purchased”
A valid scenario and a reasonable request
Here are those two views (same list of customers just sorted differently)
Sorting can have an impact on performance as well, especially, when the metric by which we are sorting has no business relevance and is not already included in the query Tableau is going to execute. There are certain situations where a specific sort is needed, but I have often found that the most important sort on a bar chart is typically the sort by metric that the bar is already displaying. No need to “dual-code” the information
Watch this the clip from the Youtube video about sorting to learn more
Data Journey 