Dimension filters in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales data by region showing total sales amounts.

Cell	Value
A1	Region
B1	Sales
A2	North
B2	1000
A3	South
B3	1500
A4	East
B4	1200
A5	West
B5	1300

Formula Trace

SUM(IF [Region] = 'North' THEN [Sales] ELSE 0 END)

Step 1: Check each row if Region = 'North'

Step 2: For each row, if True take Sales else 0

Step 3: Sum all values from step 2

Cell Reference Map

    A       B
1 |Region | Sales |
2 | North | 1000  |
3 | South | 1500  |
4 | East  | 1200  |
5 | West  | 1300  |

Filter applied on column A (Region) to select 'North' only.

The filter uses the Region column to select only rows where Region equals 'North'.

Result

    A       B
1 |Region | Sales |
2 | North | 1000  |

Total Sales after filter: 1000

After applying the dimension filter for 'North', only that row remains and the sum of Sales is 1000.

Sheet Trace Quiz - 3 Questions

What does the filter condition [Region] = 'North' do?

A Selects all rows except North

B Selects only rows where Region is North

C Changes all Regions to North

D Sums all sales regardless of Region

Key Result

Dimension filters select rows matching a condition and aggregate values only from those rows.