Label display in Tableau - Cell-by-Cell Formula Trace

Sample Data

This data shows product names and their sales amounts.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	100
A3	Bananas
B3	150
A4	Cherries
B4	120

Formula Trace

IF SUM([Sales]) > 120 THEN STR(SUM([Sales])) ELSE '' END

Step 1: SUM([Sales]) for Apples

Step 2: IF 100 > 120 THEN '100' ELSE '' END

Step 3: SUM([Sales]) for Bananas

Step 4: IF 150 > 120 THEN '150' ELSE '' END

Step 5: SUM([Sales]) for Cherries

Step 6: IF 120 > 120 THEN '120' ELSE '' END

Cell Reference Map

   |  A       |  B    
---+----------+-------
1  | Product  | Sales 
2  | Apples   | 100   
3  | Bananas  | 150   
4  | Cherries | 120   

Arrows: SUM([Sales]) reads cells B2, B3, B4 for each product row.

The formula references the Sales column (B2:B4) to calculate sums for each product.

Result

   |  A       |  B    |  C      
---+----------+-------+---------
1  | Product  | Sales | Label   
2  | Apples   | 100   |         
3  | Bananas  | 150   | 150     
4  | Cherries | 120   |         

The Label column shows sales values only if sales are greater than 120, otherwise it is blank.

Sheet Trace Quiz - 3 Questions

What label will Apples have based on the formula?

A 'Apples'

B '100'

C '' (empty)

D '120'

Key Result

IF condition THEN show label ELSE show empty string