Field sort (alphabetic, data source) in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a clear sales report where product categories are sorted alphabetically and regions are sorted by total sales from highest to lowest.

📊 Data: You have sales data including Product Category, Region, and Sales Amount for the last quarter.

🎯 Deliverable: Create a Tableau dashboard showing total sales by Product Category and Region with the specified sorting applied.

Sample Data

Product Category	Region	Sales Amount
Electronics	East	12000
Furniture	West	15000
Clothing	North	8000
Electronics	South	7000
Clothing	East	6000
Furniture	North	9000
Electronics	West	11000
Clothing	South	5000
Furniture	East	13000
Electronics	North	14000

1

Step 1: Connect Tableau to the sales data source containing Product Category, Region, and Sales Amount.

Use Tableau's 'Connect' feature to import the data table.

Expected Result

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

2

Step 2: Create a new worksheet and drag 'Product Category' to Rows and 'Sales Amount' to Columns.

Drag fields as described.

Expected Result

Bar chart showing total sales by Product Category.

3

Step 3: Sort 'Product Category' field alphabetically in ascending order.

Right-click 'Product Category' in Rows, select 'Sort', choose 'Sort by Field', Field: 'Product Category', Order: 'Ascending'.

Expected Result

Product Categories appear in alphabetical order: Clothing, Electronics, Furniture.

4

Step 4: Create a second worksheet and drag 'Region' to Rows and 'Sales Amount' to Columns.

Drag fields as described.

Expected Result

Bar chart showing total sales by Region.

5

Step 5: Sort 'Region' field by total sales in descending order.

Right-click 'Region' in Rows, select 'Sort', choose 'Sort by Field', Field: 'Sales Amount', Aggregation: 'Sum', Order: 'Descending'.

Expected Result

Regions sorted by total sales from highest to lowest.

6

Step 6: Create a dashboard and add both worksheets with clear titles.

Use 'New Dashboard', drag worksheets, add titles 'Sales by Product Category' and 'Sales by Region'.

Expected Result

Dashboard shows two charts with correct sorting applied.

Final Result

Dashboard: Sales Report

+---------------------------+  +-------------------------+
| Sales by Product Category  |  | Sales by Region          |
|                           |  |                         |
| Clothing       ████        |  | East          ████████  |
| Electronics    ████████    |  | North         ████████  |
| Furniture     ███████      |  | West          ███████   |
|                           |  | South         ███       |
+---------------------------+  +-------------------------+

✓Product categories are sorted alphabetically: Clothing, Electronics, Furniture.

✓Regions are sorted by total sales descending: East and North (tied), followed by West, and South.

✓East and North regions have the highest total sales among all regions.

Bonus Challenge

Add a filter to the dashboard to allow users to select a specific quarter and see the updated sorted sales data.

Show Hint

Use Tableau's filter feature on the date field and ensure sorting updates dynamically with the filter.