Nested Sorting Tip

A quick tip to do nested sorting quickly. Here an example. Build your viz: put your measure on columns (category and region in this case) and your dimension on rows (Sum of Sales). If you need to sort your category by sum of sales for each region you:

  • Duplicate your sales and you drag it to columns
  • Type a minus in the front of Sum of Sales

  • Change it to discrete
  • Drag it between Category and Region