Why sorting organizes visual display in Tableau - Business Case Study

Scenario Mode

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

📋 Request: Your manager wants you to create a clear sales report that shows the top-selling products in order, so the team can focus on the best performers.

📊 Data: You have monthly sales data for different products, including product names and total sales amounts.

🎯 Deliverable: Create a Tableau bar chart sorted by total sales from highest to lowest to clearly show the best-selling products.

Sample Data

Product	Month	Sales
Notebook	January	1200
Pen	January	800
Backpack	January	1500
Notebook	February	1300
Pen	February	900
Backpack	February	1400
Notebook	March	1100
Pen	March	950
Backpack	March	1600

1

Step 1: Connect your Tableau workbook to the sales data source.

Use 'Product', 'Month', and 'Sales' columns from the data.

Expected Result

Data is loaded and ready for analysis.

2

Step 2: Create a calculated field to sum total sales per product across all months.

Create a calculated field named 'Total Sales' with formula: SUM([Sales])

Expected Result

Total sales per product will be calculated.

3

Step 3: Build a bar chart with 'Product' on Rows and 'Total Sales' on Columns.

Drag 'Product' to Rows shelf and 'Total Sales' to Columns shelf.

Expected Result

A bar chart showing total sales for each product appears.

4

Step 4: Sort the products by 'Total Sales' in descending order to show top sellers first.

Click on the sort icon on the 'Product' field and choose 'Sort by Field', select 'Total Sales', aggregation 'Sum', order 'Descending'.

Expected Result

Bars are ordered from highest to lowest sales, making top products easy to see.

5

Step 5: Add labels to the bars to show exact sales numbers for clarity.

Drag 'Total Sales' to Label on the Marks card.

Expected Result

Each bar displays its total sales value.

Final Result

Product Sales Bar Chart

Backpack  | ██████████████████ 4500
Notebook  | ██████████████ 3600
Pen       | ██████████ 2650

Bars sorted from highest to lowest sales.

✓Backpack is the top-selling product with total sales of 4500.

✓Notebook is the second best with 3600 sales.

✓Pen has the lowest sales among the three products with 2650.

Bonus Challenge

Create a dashboard that includes the sorted sales bar chart and a filter to select sales by month.

Show Hint

Use a filter action on the 'Month' field and add it to the dashboard to let users choose which month's sales to display.