Why filtering focuses analysis in Tableau - Formula Trace Breakdown

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] = 'South' THEN [Sales] ELSE 0 END)

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

Step 2: Apply IF condition: IF Region='South' THEN Sales ELSE 0

Step 3: SUM the filtered sales values

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 'South' only.

The formula filters data by checking Region column values and sums Sales only for 'South'.

Result

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

Total Filtered Sales: 1500

Filtered sales column shows sales only for 'South' region, zeros elsewhere. The sum of this column is 1500, focusing analysis on one region.

Sheet Trace Quiz - 3 Questions

What does the IF condition in the formula do?

A Keeps sales only for 'South' region and replaces others with zero

B Adds sales for all regions

C Filters out sales for 'South' region

D Multiplies sales by region name

Key Result

Filtering with IF condition selects specific rows, then aggregation sums only those filtered values.