Dimensions vs measures concept in Tableau - Formula Comparison Trace

Sample Data

Sales data by region. 'Region' is a dimension (category), 'Sales' is a measure (numeric value).

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(B2:B5)

Step 1: SUM(1000, 1500, 1200, 1300)

Cell Reference Map

North

↓

South

↓

East

↓

West

The formula references sales values in cells B2 to B5 to calculate total sales measure.

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 measure (5000) is calculated by summing sales values. 'Region' is a dimension used to group data.

Sheet Trace Quiz - 3 Questions

What type of data is 'Region' in this example?

A Calculated field

B Dimension (category)

C Measure (numeric value)

D Filter

Key Result

SUM(range) adds numeric values in a measure column to produce an aggregated result.