0
0
Tableaubi_tool~10 mins

Filter actions in Tableau - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales data by region. Column A lists regions, column B shows sales amounts.

CellValue
A1Region
B1Sales
A2East
B21000
A3West
B31500
A4North
B41200
A5South
B51300
Formula Trace
FILTER([Region] = 'West')
Step 1: [Region] = 'West'
Step 2: FILTER rows where condition is True
Cell Reference Map
    A       B
1 |Region |Sales
2 |East   |1000
3 |West   |1500 <- Filtered
4 |North  |1200
5 |South  |1300
The filter action checks the Region column (A) for 'West' and keeps only that row.
Result
    A       B
3 |West   |1500
After applying the filter action, only the row with Region 'West' and Sales 1500 is shown.
Sheet Trace Quiz - 3 Questions
Test your understanding
Which row remains after applying the filter action FILTER([Region] = 'West')?
ARow with Region 'West' and Sales 1500
BRow with Region 'East' and Sales 1000
CRow with Region 'South' and Sales 1300
DAll rows remain
Key Result
FILTER(condition) keeps only rows where condition is True