Tip Week- Day one, tip one

by Giorgia Umani

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

Mon 29 Jan 2018

Mon 18 Dec 2017

© 2022 The Information Lab Ltd. All rights reserved.