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

Sample Data

This data shows sales amounts for four regions.

Cell	Value
A1	Region
B1	Sales
A2	East
B2	1000
A3	West
B3	1500
A4	North
B4	1200
A5	South
B5	1300

Formula Trace

SUM([Sales])

Step 1: SUM([Sales])

Step 2: 1000 + 1500 + 1200 + 1300

Cell Reference Map

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

[Sales] references cells B2 to B5

The formula references the Sales column cells B2 to B5 to calculate the total sales.

Result

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

The text table shows sales by region and the total sales of 5000 at the bottom.

Sheet Trace Quiz - 3 Questions

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

A The sales for the East region only

B The average sales per region

C The total sales from all regions

D The number of regions

Key Result

SUM aggregates numeric values from a specified column to produce a total.