Performance considerations in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales data by region used to demonstrate performance considerations in Tableau calculations.

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 references the Sales column (cells B2 to B5) to calculate the total sales.

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 value 5000 is displayed in cell C2, showing the sum of all sales.

Sheet Trace Quiz - 3 Questions

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

A The average sales per region

B The total sales across all regions

C The sales for the North region only

D The maximum sales value

Key Result

SUM aggregates values in a column to produce a total.