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.