Tableau Cloud basics - Cell-by-Cell Formula Trace

Sample Data

Sales data by region used to demonstrate Tableau Cloud basics.

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([Sales])

Step 1: SUM([Sales])

Cell Reference Map

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

[Sales] references cells B2 to B5

The formula uses the Sales column values from cells B2 to B5.

Result

   A       B       C
1 Region  Sales   Total Sales
2 North   1000    5000
3 South   1500    
4 East    1200    
5 West    1300    

The Total Sales column shows the sum of all sales values, 5000, calculated by the formula.

Sheet Trace Quiz - 3 Questions

What does the formula SUM([Sales]) calculate?

A The total of all sales values

B The average sales value

C The highest sales value

D The number of sales entries

Key Result

SUM aggregates all values in a specified column to produce a total.