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

Sample Data

Sales data by region showing sales amounts for different regions.

Cell	Value
A1	Region
B1	Sales
A2	East
B2	100
A3	West
B3	200
A4	East
B4	150
A5	West
B5	300
A6	North
B6	250

Formula Trace

SUM(Sales) with Context Filter Region='East'

Step 1: Apply context filter Region='East' to data

Step 2: Sum Sales values in filtered rows (100 + 150)

Cell Reference Map

    A       B
1 |Region | Sales
2 | East  | 100  <--- Included by context filter
3 | West  | 200
4 | East  | 150  <--- Included by context filter
5 | West  | 300
6 | North | 250

Context filter uses Region column to include only rows with 'East'. Sales column values from those rows are summed.

Result

    A       B
1 |Region | Sales
2 | East  | 100
4 | East  | 150

Result: Total Sales = 250

After applying the context filter for Region='East', only rows 2 and 4 remain. Their sales values sum to 250.

Sheet Trace Quiz - 3 Questions

What does the context filter do in this example?

A It filters sales greater than 200

B It limits data to only rows where Region is East

C It sums all sales regardless of region

D It excludes East region rows

Key Result

Context filters first limit data rows, then aggregations like SUM operate only on filtered data.