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.

Practice

1. What does sorting fields alphabetically in Tableau do?

easy

A. It changes the data source order permanently.

B. It arranges fields in the Data pane from A to Z by their names.

C. It sorts data rows in the worksheet alphabetically.

D. It filters out fields that don't start with a letter.

Solution

1. Step 1: Understand field sorting in Tableau

   Sorting fields alphabetically arranges the field names in the Data pane from A to Z.

2. Step 2: Differentiate from data sorting

   This sorting affects only the field list, not the data rows or data source order.

3. Final Answer:

   It arranges fields in the Data pane from A to Z by their names. -> Option B

4. Quick Check:

   Field names sorted alphabetically = It arranges fields in the Data pane from A to Z by their names. [OK]

Hint: Alphabetic sort orders field names A to Z in the Data pane [OK]

Common Mistakes:

• Confusing field sorting with data row sorting
• Thinking it changes data source order
• Assuming it filters fields

2. Which menu option in Tableau lets you sort fields by data source order?

easy

A. Right-click Data pane > Sort > Data Source Order

B. Right-click Data pane > Sort > Alphabetic

C. Worksheet menu > Sort Fields > Data Source

D. Data menu > Sort > Manual

Solution

1. Step 1: Locate sorting options in Tableau

   Right-clicking the Data pane shows a Sort submenu with options including Alphabetic and Data Source Order.

2. Step 2: Identify correct option for data source order

   Selecting 'Data Source Order' sorts fields as they appear in the original data source.

3. Final Answer:

   Right-click Data pane > Sort > Data Source Order -> Option A

4. Quick Check:

   Data Source Order sorting = Right-click Data pane > Sort > Data Source Order [OK]

Hint: Right-click Data pane > Sort > Data Source Order for original field order [OK]

Common Mistakes:

• Choosing Alphabetic instead of Data Source Order
• Looking in Worksheet or Data menu instead of Data pane
• Selecting Manual sort which is not for data source order

3. If you sort fields alphabetically in Tableau, which field order will you see in the Data pane?
Fields: Sales, Profit, Customer, Date

medium

A. Profit, Sales, Customer, Date

B. Sales, Profit, Customer, Date

C. Date, Customer, Profit, Sales

D. Customer, Date, Profit, Sales

Solution

1. Step 1: List fields alphabetically

   Sort the fields by their names alphabetically: Customer, Date, Profit, Sales.

2. Step 2: Compare with given options

   Customer, Date, Profit, Sales matches the alphabetical order exactly.

3. Final Answer:

   Customer, Date, Profit, Sales -> Option D

4. Quick Check:

   Alphabetic order = Customer, Date, Profit, Sales [OK]

Hint: Alphabetic sort orders fields by name A to Z [OK]

Common Mistakes:

• Assuming original data source order is kept
• Mixing up alphabetical order
• Choosing random order

4. You tried to sort fields by data source order but the fields remain alphabetically sorted. What is the likely issue?

medium

A. You need to refresh the data source first.

B. Tableau does not support sorting by data source order.

C. You did not select 'Data Source Order' in the sort menu.

D. Fields cannot be sorted in the Data pane.

Solution

1. Step 1: Understand sorting options

   Tableau supports sorting fields by Alphabetic or Data Source Order via the Data pane menu.

2. Step 2: Identify common user mistake

   If fields remain alphabetically sorted, likely the user did not choose 'Data Source Order' explicitly.

3. Final Answer:

   You did not select 'Data Source Order' in the sort menu. -> Option C

4. Quick Check:

   Not selecting correct sort option = You did not select 'Data Source Order' in the sort menu. [OK]

Hint: Always confirm 'Data Source Order' is selected to change sort [OK]

Common Mistakes:

• Assuming Tableau lacks data source order sorting
• Forgetting to refresh data source
• Thinking fields cannot be sorted

5. You have a Data pane with fields ordered as: Region, Sales, Profit, Date. You want to sort fields alphabetically but keep 'Date' always last. How can you achieve this in Tableau?

hard

A. Sort alphabetically, then manually drag 'Date' to the bottom.

B. Sort by data source order and rename 'Date' to start with 'Z'.

C. Use a calculated field to exclude 'Date' from sorting.

D. Tableau does not allow custom sorting of fields.

Solution

1. Step 1: Apply alphabetic sort

   Sort fields alphabetically to order them by name automatically.

2. Step 2: Manually adjust 'Date' position

   Drag the 'Date' field manually to the bottom to keep it last.

3. Final Answer:

   Sort alphabetically, then manually drag 'Date' to the bottom. -> Option A

4. Quick Check:

   Manual drag after sort = Sort alphabetically, then manually drag 'Date' to the bottom. [OK]

Hint: Sort alphabetically, then drag exceptions manually [OK]

Common Mistakes:

• Thinking data source order can fix custom exceptions
• Trying to exclude fields via calculation
• Believing Tableau disallows manual field order