Creating parameters in Tableau - Formula Evaluation Walkthrough

Sample Data

Sales data by region

Cell	Value
A1	Sales
A2	100
A3	200
A4	150
B1	Region
B2	East
B3	West
B4	East

Formula Trace

IF [Region] = [Selected Region] THEN [Sales] ELSE 0 END

Step 1: [Selected Region]

Step 2: [Region] = [Selected Region] for each row

Step 3: IF condition THEN [Sales] ELSE 0 for each row

Cell Reference Map

   A       B       
1 Sales   Region   
2 100     East  <-- Selected Region = East
3 200     West   
4 150     East  

The formula uses the Region column and the parameter 'Selected Region' to filter Sales.

Result

   A       B       C
1 Sales   Region  Filtered Sales
2 100     East       100
3 200     West        0
4 150     East       150

Filtered Sales column shows sales only for the selected region 'East'.

Sheet Trace Quiz - 3 Questions

What value does the parameter 'Selected Region' hold in this example?

A "West"

B "East"

C "North"

D "South"

Key Result

IF [Dimension] = [Parameter] THEN [Measure] ELSE 0 END