0
0
Tableaubi_tool~10 mins

Highlight tables in Tableau - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales data by region showing sales amounts.

CellValue
A1Region
B1Sales
A2North
B25000
A3South
B37000
A4East
B43000
A5West
B56000
Formula Trace
SUM([Sales])
Step 1: SUM([Sales])
Cell Reference Map
    A       B
1 |Region | Sales |
2 | North | 5000  |
3 | South | 7000  |
4 | East  | 3000  |
5 | West  | 6000  |

[Sales] references cells B2 to B5
The formula uses the Sales column values from B2 to B5.
Result
    A       B       C
1 |Region | Sales | Highlight |
2 | North | 5000  |  Medium   |
3 | South | 7000  |   High    |
4 | East  | 3000  |   Low     |
5 | West  | 6000  |  Medium   |
Highlight table colors sales values: High for largest, Medium for middle, Low for smallest sales.
Sheet Trace Quiz - 3 Questions
Test your understanding
What is the total sales calculated by SUM([Sales])?
A18000
B21000
C25000
D20000
Key Result
SUM aggregates numeric values in a column to a single total.