Multiple data sources in Tableau - Cell-by-Cell Formula Trace

Sample Data

Two data sources: Sales data with ProductID and SalesAmount, and Product data with ProductID and ProductName.

Cell	Value
A1	ProductID
B1	SalesAmount
A2	101
B2	200
A3	102
B3	150
D1	ProductID
E1	ProductName
D2	101
E2	Chair
D3	102
E3	Table

Formula Trace

SUM([SalesAmount]) for products where [ProductName] = 'Chair'

Step 1: Join Sales data and Product data on ProductID

Step 2: Filter rows where ProductName = 'Chair'

Step 3: Sum SalesAmount for filtered rows

Cell Reference Map

  A       B       D       E  
1 ProductID SalesAmount  ProductID ProductName
2 101       200    101       Chair
3 102       150    102       Table

Arrows: Sales.ProductID -> Product.ProductID for join

The formula uses ProductID from both Sales and Product data to join and filter by ProductName.

Result

  F       
1 TotalSales
2 200     

The final result shows total sales amount for the product named Chair, which is 200.

Sheet Trace Quiz - 3 Questions

What is the purpose of joining the two data sources on ProductID?

A To combine sales amounts with product names

B To filter sales by date

C To calculate average sales

D To remove duplicate sales records

Key Result

Join data sources on common key, filter by condition, then aggregate measure