Ascending and descending sort in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants to see the list of products sorted by total sales, first in ascending order and then in descending order, to understand which products are selling the least and which are selling the most.

📊 Data: You have sales data including Product Name, Category, and Sales Amount for each transaction.

🎯 Deliverable: Create two views in Tableau: one showing products sorted by total sales in ascending order, and another showing products sorted by total sales in descending order.

Sample Data

Product Name	Category	Sales Amount
Notebook	Stationery	120
Pen	Stationery	80
Desk Chair	Furniture	450
Monitor	Electronics	700
Mouse	Electronics	150
Stapler	Stationery	60
Desk Lamp	Furniture	200
Keyboard	Electronics	300

1

Step 1: Open Tableau and connect to the sales data source.

Connect to the data file or database containing Product Name, Category, and Sales Amount columns.

Expected Result

Data is loaded and visible in Tableau's Data pane.

2

Step 2: Create a new worksheet and drag 'Product Name' to Rows shelf.

Drag 'Product Name' field from Data pane to Rows shelf.

Expected Result

List of products appears vertically on the left side.

3

Step 3: Drag 'Sales Amount' to Columns shelf and set aggregation to SUM.

Drag 'Sales Amount' field to Columns shelf; ensure aggregation is SUM (default).

Expected Result

Horizontal bars appear representing total sales per product.

4

Step 4: Sort the products in ascending order by total sales.

Click the sort icon on the 'Product Name' pill in Rows shelf, choose 'Sort Ascending' by 'Field' SUM(Sales Amount).

Expected Result

Products are listed from lowest to highest total sales.

5

Step 5: Duplicate the worksheet to create a second view.

Right-click the worksheet tab and select 'Duplicate'.

Expected Result

A copy of the worksheet appears as a new tab.

6

Step 6: In the duplicated worksheet, sort the products in descending order by total sales.

Click the sort icon on the 'Product Name' pill in Rows shelf, choose 'Sort Descending' by 'Field' SUM(Sales Amount).

Expected Result

Products are listed from highest to lowest total sales.

7

Step 7: Create a dashboard to display both views side by side.

Create new dashboard, drag both worksheets onto it side by side, add titles 'Ascending Sales' and 'Descending Sales'.

Expected Result

Dashboard shows two sorted product lists for easy comparison.

Final Result

Dashboard: Ascending and Descending Product Sales

+----------------------+  +-----------------------+
| Ascending Sales       |  | Descending Sales       |
|                      |  |                       |
| Stapler       | 60    |  | Monitor       | 700    |
| Pen           | 80    |  | Desk Chair    | 450    |
| Notebook      | 120   |  | Keyboard      | 300    |
| Mouse         | 150   |  | Desk Lamp     | 200    |
| Desk Lamp     | 200   |  | Mouse         | 150    |
| Keyboard      | 300   |  | Notebook      | 120    |
| Desk Chair    | 450   |  | Pen           | 80     |
| Monitor       | 700   |  | Stapler       | 60     |
+----------------------+  +-----------------------+

✓Stapler has the lowest total sales at 60.

✓Monitor has the highest total sales at 700.

✓Sorting helps quickly identify best and worst selling products.

Bonus Challenge

Add a filter to the dashboard to allow sorting products within each category separately.

Show Hint

Use a Category filter on the dashboard and apply sorting within the filtered data.

Practice

1. In Tableau, what does sorting data in ascending order do?

easy

A. It arranges data from smallest to largest values.

B. It arranges data from largest to smallest values.

C. It groups data by categories alphabetically.

D. It filters out duplicate data points.

Solution

1. Step 1: Understand ascending sort meaning

   Ascending order means arranging values starting from the smallest and going to the largest.

2. Step 2: Apply to Tableau sorting

   In Tableau, sorting ascending will show data from smallest to largest values.

3. Final Answer:

   It arranges data from smallest to largest values. -> Option A

4. Quick Check:

   Ascending = smallest to largest [OK]

Hint: Ascending means smallest to largest values [OK]

Common Mistakes:

• Confusing ascending with descending order
• Thinking sorting filters data
• Assuming sorting groups data instead

2. Which of the following is the correct way to sort a field in descending order in Tableau?

easy

A. Click the field header once to toggle descending sort.

B. Use the Sort menu and choose 'Descending'.

C. Right-click the field header and select 'Sort Ascending'.

D. Drag the field to the Filters shelf.

Solution

1. Step 1: Identify sorting options in Tableau

   Tableau allows sorting via the Sort menu where you can explicitly choose ascending or descending.

2. Step 2: Confirm descending sort method

   Choosing 'Descending' in the Sort menu correctly sorts data from largest to smallest.

3. Final Answer:

   Use the Sort menu and choose 'Descending'. -> Option B

4. Quick Check:

   Sort menu + Descending = correct method [OK]

Hint: Use Sort menu for clear ascending/descending choice [OK]

Common Mistakes:

• Clicking field header once only sorts ascending
• Dragging fields to Filters shelf does not sort
• Selecting 'Sort Ascending' sorts opposite order

3. Given a Tableau bar chart sorted descending by Sales, what will be the order of bars if Sales values are: 100, 250, 50, 300?

medium

A. 300, 250, 100, 50

B. 250, 300, 100, 50

C. 100, 50, 250, 300

D. 50, 100, 250, 300

Solution

1. Step 1: Understand descending sort order

   Descending order arranges values from largest to smallest.

2. Step 2: Sort given Sales values descending

   Values sorted descending: 300, 250, 100, 50.

3. Final Answer:

   300, 250, 100, 50 -> Option A

4. Quick Check:

   Descending sort = largest to smallest [OK]

Hint: Descending means largest value first [OK]

Common Mistakes:

• Sorting ascending instead of descending
• Mixing up order of values
• Assuming default order is alphabetical

4. You tried to sort a dimension in Tableau descending but the data still appears ascending. What is the likely cause?

medium

A. Tableau does not support descending sort on dimensions.

B. The data source is corrupted and cannot sort.

C. You applied sorting on a measure instead of a dimension.

D. You clicked 'Sort Ascending' instead of 'Sort Descending'.

Solution

1. Step 1: Check sorting action performed

   Clicking 'Sort Ascending' will keep data in ascending order, not descending.

2. Step 2: Verify Tableau sorting capabilities

   Tableau supports descending sort on dimensions; data source corruption is unlikely cause.

3. Final Answer:

   You clicked 'Sort Ascending' instead of 'Sort Descending'. -> Option D

4. Quick Check:

   Wrong sort direction clicked = ascending shown [OK]

Hint: Double-check sort direction clicked in Tableau [OK]

Common Mistakes:

• Assuming Tableau can't sort dimensions descending
• Blaming data source without checking sort settings
• Sorting measure instead of dimension by mistake

5. You have a sales report with Product Categories and Sales. You want to show the top 3 categories by sales in descending order. Which steps should you follow in Tableau?

hard

A. Sort Product Categories ascending by Sales, then filter top 3.

B. Sort Product Categories descending by Sales, then filter top 3.

C. Filter top 3 Product Categories by Sales, then sort descending by Sales.

D. Filter top 3 Product Categories by Sales, then sort ascending by Sales.

Solution

1. Step 1: Filter top 3 Product Categories by Sales

   Apply a filter to keep only the top 3 categories based on Sales values.

2. Step 2: Sort the filtered categories descending by Sales

   Sort these top 3 categories so the highest sales appear first.

3. Final Answer:

   Filter top 3 Product Categories by Sales, then sort descending by Sales. -> Option C

4. Quick Check:

   Filter top 3 first, then descending sort [OK]

Hint: Filter top 3 first, then sort descending [OK]

Common Mistakes:

• Sorting before filtering top 3
• Sorting ascending instead of descending
• Filtering after sorting ascending