Adding sheets to dashboard in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sample sales and profit data by region to be visualized in Tableau sheets.

Cell	Value
A1	Sales
A2	1000
B1	Profit
B2	200
C1	Region
C2	East
C3	West
C4	North
C5	South
A3	1500
B3	300
A4	1200
B4	250
A5	1300
B5	270

Formula Trace

Add Sheet1 and Sheet2 to Dashboard

Step 1: Open Tableau and create Sheet1 with Sales by Region

Step 2: Create Sheet2 with Profit by Region

Step 3: Open a new Dashboard

Step 4: Drag Sheet1 onto the dashboard

Step 5: Drag Sheet2 onto the dashboard

Step 6: Arrange sheets and add titles if needed

Cell Reference Map

    A       B       C
1 |Sales | Profit | Region
2 | 1000 |  200   | East  
3 | 1500 |  300   | West  
4 | 1200 |  250   | North 
5 | 1300 |  270   | South 

Arrows: Sheet1 uses columns A and C; Sheet2 uses columns B and C

Sheet1 uses Sales and Region columns; Sheet2 uses Profit and Region columns from the data.

Result

Dashboard:
+-------------------+-------------------+
|   Sheet1: Sales   |   Sheet2: Profit  |
| East: 1000        | East: 200         |
| West: 1500        | West: 300         |
| North: 1200       | North: 250        |
| South: 1300       | South: 270        |
+-------------------+-------------------+

The dashboard shows two sheets side by side: sales by region and profit by region, allowing easy comparison.

Sheet Trace Quiz - 3 Questions

Which columns are used in Sheet1?

A Sales and Region

B Profit and Region

C Sales and Profit

D Region only

Key Result

Adding sheets to a dashboard involves dragging existing sheets onto a blank dashboard canvas and arranging them.