Embedded analytics in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales data by region used to demonstrate embedding a Tableau visualization into a web page.

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 value 5000 is calculated and displayed next to the sales data.

Sheet Trace Quiz - 3 Questions

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

A The sales for the North region only

B The average sales per region

C The total sales across all regions

D The difference between highest and lowest sales

Key Result

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