Manual sort order in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a sales report that shows product categories in a specific order: 'Electronics', 'Furniture', 'Office Supplies', regardless of alphabetical or sales values.

📊 Data: You have monthly sales data with columns: Product Category, Month, and Sales Amount.

🎯 Deliverable: Create a Tableau bar chart showing total sales by product category sorted in the requested manual order.

Sample Data

Product Category	Month	Sales Amount
Electronics	January	12000
Furniture	January	8000
Office Supplies	January	5000
Electronics	February	15000
Furniture	February	7000
Office Supplies	February	6000
Electronics	March	13000
Furniture	March	9000
Office Supplies	March	5500

1

Step 1: Connect your sales data to Tableau and open a new worksheet.

No formula needed.

Expected Result

Data is loaded and ready for analysis.

2

Step 2: Create a calculated field to assign manual sort order numbers to product categories.

Create calculated field named 'Category Sort Order' with formula: CASE [Product Category] WHEN 'Electronics' THEN 1 WHEN 'Furniture' THEN 2 WHEN 'Office Supplies' THEN 3 ELSE 4 END

Expected Result

Each product category has a numeric sort order: Electronics=1, Furniture=2, Office Supplies=3.

3

Step 3: Drag 'Product Category' to Rows shelf and 'Sales Amount' to Columns shelf to create a bar chart.

No formula needed.

Expected Result

Bar chart shows total sales by product category in default order.

4

Step 4: Sort the 'Product Category' field manually using the 'Category Sort Order' calculated field.

Right-click 'Product Category' on Rows shelf > Sort > Sort by Field > Choose 'Category Sort Order' > Ascending.

Expected Result

Bars are ordered as Electronics first, Furniture second, Office Supplies third.

5

Step 5: Format the chart with clear axis titles and labels for accessibility.

Set axis title to 'Total Sales', add data labels on bars, ensure color contrast is high.

Expected Result

Chart is easy to read and accessible.

Final Result

Product Category Sales Report

| Electronics    | ██████████████████ 40,000 |
| Furniture      | ████████████      24,000 |
| Office Supplies| ████████          16,500 |

(X-axis: Total Sales, Y-axis: Product Category in manual order)

✓Electronics is the top-selling category.

✓Furniture sales are second highest.

✓Office Supplies have the lowest sales among the three categories.

Bonus Challenge

Create a parameter to let users choose the manual sort order dynamically.

Show Hint

Use a parameter with category names and update the calculated field to use the parameter values for sorting.