SYMPTOM:
In some business scenarios it is required to sort by the Revenue of each parent attribute first, then within each parent attribute to sort child attribute alphabetically. Below is one solution in the Tutorial project as an example.
STEPS TO REPRODUCE:
1. Create a Revenue metric at Category level as below and name it as "A":
Sum(Revenue){~, Category}
5. And the grid will look like below. It is sorting by Subtotal of Category, and within each Category, it is sorting by Subcategory alphabetically.
6. Go to Grid -> Options and hide the column of metric "A":
7. The final result is as below.
