The Ranking button, for filtering a dimension based on its corresponding measures, will return the top or bottom ranked results. Consider the 15th ranked result. What if there were 16 values at the bottom that are evenly ranked? In this case, requesting the top 15 results returns 30 values, 16 of which are for 4 orders.
Consider a pie chart when the ranking for the top 15 values returns these 30:
The messy pie chart would look like this:
If I want to limit the results to just 15 results (returning just one of the 16 values of 4), then I need a number to differentiate those 16.
In this case, I used the Max(). Any unique numbering will do. An ID number might work perfectly.
I created a variable called Orders =ToNumber(+”.”+Max()).
Creating the ranking of the Customer Cities based on the top 15 Orders, returns these results:
The much cleaner pie chart looks like this: