0
0
Tableaubi_tool~10 mins

Dynamic dimension swap in Tableau - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales data by Region and Category

CellValue
A1Region
B1Category
C1Sales
A2East
B2Furniture
C21000
A3East
B3Technology
C31500
A4West
B4Furniture
C42000
A5West
B5Technology
C52500
Formula Trace
IF [Selected Dimension] = 'Region' THEN [Region] ELSE [Category] END
Step 1: [Selected Dimension]
Step 2: [Selected Dimension] = 'Region'
Step 3: IF TRUE THEN [Region] ELSE [Category] END
Step 4: Return value for row 2
Step 5: Return value for row 3
Step 6: Return value for row 4
Step 7: Return value for row 5
Cell Reference Map
Selected Dimension
↓
Region
The formula uses the user-selected dimension to pick either the Region or Category column values.
Result
    D
1 | Dynamic Dimension
2 | East
3 | East
4 | West
5 | West
The dynamic dimension column shows Region values because 'Region' was selected.
Sheet Trace Quiz - 3 Questions
Test your understanding
What value does the formula return for row 3 when 'Region' is selected?
AFurniture
BTechnology
CEast
DWest
Key Result
IF [Selected Dimension] = 'Region' THEN [Region] ELSE [Category] END