Arithmetic calculations in Tableau - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants to understand the profit performance by calculating profit and profit margin for each product category.

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

🎯 Deliverable: Create a Tableau dashboard showing total sales, total cost, total profit, and profit margin by product category.

Sample Data

Product Category	Sales Amount	Cost Amount
Electronics	1200	800
Furniture	850	600
Clothing	600	400
Electronics	1500	1000
Furniture	700	500
Clothing	900	650
Electronics	1300	900
Furniture	950	700
Clothing	750	500

1

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

No formula needed; just connect the data source.

Expected Result

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

2

Step 2: Create a calculated field named 'Profit' to find the difference between Sales Amount and Cost Amount.

[Sales Amount] - [Cost Amount]

Expected Result

Profit is calculated for each row.

3

Step 3: Create a calculated field named 'Profit Margin' to calculate profit margin as a percentage.

SUM([Profit]) / SUM([Sales Amount])

Expected Result

Profit Margin is calculated as a proportion using total profit over total sales.

4

Step 4: Build a worksheet with 'Product Category' on Rows, and SUM of Sales Amount, SUM of Cost Amount, SUM of Profit, and Profit Margin on Columns.

Drag 'Product Category' to Rows; drag 'Sales Amount', 'Cost Amount', and 'Profit' to Columns and set aggregation to SUM; drag 'Profit Margin' to Columns (no aggregation needed as it is already aggregated).

Expected Result

Table shows total sales, total cost, total profit, and profit margin by product category.

5

Step 5: Format the Profit Margin column to show percentage with one decimal place.

Right-click 'Profit Margin' field > Format > Numbers > Percentage > 1 decimal place.

Expected Result

Profit Margin values display as percentages with one decimal.

6

Step 6: Create a dashboard and add the worksheet to it for presentation.

Drag the worksheet onto the dashboard canvas.

Expected Result

Dashboard displays the profit analysis by product category.

Final Result

Product Category | Sales Amount | Cost Amount | Profit | Profit Margin
-----------------------------------------------------------------------
Electronics      | 4000         | 2700        | 1300   | 32.5%
Furniture        | 2500         | 1800        | 700    | 28.0%
Clothing         | 2250         | 1550        | 700    | 31.1%

✓Electronics has the highest total sales and profit.

✓Furniture has the lowest profit margin among the categories.

✓Clothing has a strong profit margin close to Electronics.

Bonus Challenge

Add a filter to the dashboard to allow users to select specific product categories and see updated profit calculations.

Show Hint

Use a 'Product Category' filter on the dashboard and set it to show only relevant categories when selected.