Why calculations extend data analysis in Tableau - Formula Trace Breakdown

Sample Data

Sales data by region showing total sales amounts.

Cell	Value
A1	Region
B1	Sales
A2	North
B2	100
A3	South
B3	150
A4	East
B4	200
A5	West
B5	50

Formula Trace

SUM([Sales]) * 1.1

Step 1: SUM([Sales])

Step 2: 500 * 1.1

Cell Reference Map

   A       B
1 Region  Sales
2 North   100
3 South   150
4 East    200
5 West     50

[Sales] references cells B2 to B5

The formula uses the Sales column (B2:B5) to calculate total sales.

Result

   A       B       C
1 Region  Sales   Total with Growth
2 North   100     
3 South   150     
4 East    200     
5 West     50     550

The calculated field 'Total with Growth' shows 550 as the total sales increased by 10%.

Sheet Trace Quiz - 3 Questions

What does the SUM([Sales]) part of the formula do?

A Adds all sales values together

B Multiplies sales by 1.1

C Subtracts sales values

D Divides sales values by 4

Key Result

SUM aggregates values, then multiplication applies a growth factor to extend analysis.