Sorting and Top N Analysis in Tableau

Sorting in Tableau - 

Lets Understand sorting in Tableau by Creating a simple Example -

1. I have already extracted data of few customer, Now the first step is go to your  worksheet and Choose a Field like I choose Customer Name from dimension and drop in Column Shelve

2. Add Sum(Sales) in Row Shelve.

3. Click on Customer Name (Drop down)in Column Shelve and Choose Sort

4. Now in Sort Popup Window Choose the Sort by option, like Data Source order, Alphabetic, Field, Manual or Nested. I want my Visualization sorted based on Sum(Sales), so I choose Field Option.

5. Now Choose type of sort you want like Ascending or Descending radio button as per your requirement.

6. Now Choose Field Name and the aggregate Function, like I want sorting based on Sum of sales amount so Choose Sales in Field Name and Sum in Aggregation.

You can also do sorting by Clicking on sort button available near the Axis Caption Name (See small little video available below)

Top N Analysis - 

Suppose we have to perform Analysis based on top 10 cities based on Profit. so here are few steps to do that - 

We need to create a report of top 10 Cities based on Profit and we also want to showcase Sales of those cities in Graph

1. Create a Set of Top 10 Cities based on Profit see in Below images  - 

2. Give any Name for your newly created Set, and select Top 10 in By Field Section from Create Set pop - 

3. Add Newly created Field from sets to Column Shelve and add Sales and Profit in Row Shelve 

4. Click on Drop down for Sum(Profit) as shown in below image and Choose Dual Axis to create a Dual Axis Chart

  

5. See Below Analysis created by above step, it has Sales and Profit for top 10 Cities(Who has highest profit)

Back to Tableau Home Page

Related Posts:

• Component of Tableau Desktop
• Connect to a Data Source in Tableau
• Difference Between Live Connection and Extract Data
• Types of Variable in Tableau - Datatypes
• How to Edit Datatype of a Column/Variable in Tableau
• Dimensions & Measures in Tableau
• Creating First Visualization in Tableau
• Types of Chart available in Show Me Pane - Tableau
• Learn Creating Sets in Tableau
• Different Type of Filters in Tableau