From the course: Tableau 2024.1: Essential Training

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Create a nested sort

Create a nested sort - Tableau Tutorial

From the course: Tableau 2024.1: Essential Training

Start my 1-month free trial Buy for my team

Create a nested sort

“

Sorting data when you have a single field in the rows area, and also a single field in the data area is a straightforward operation. However, there are more complicated cases where you need to create a different kind of sort, and in this movie I will show you how to do that. My sample file is 06_02_Nested, and you can find it in the Chapter_06 folder of the Exercise Files collection. In this workbook I have sales broken down by region and also by product category. The sales regions are listed in alphabetical order, and the product categories within each region are also listed in alphabetical order. So that means that the total sales which we have in the data area follow the order of batteries, EV charger, and so on for each of the regions. If I want to change the sort order so that product categories are sorted based on the values in the data area, in this case sales total, then I need to create what is called a nested sort. And we call it nested. Because if you think of a bird's…

Contents