Detail level of marks in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales data by Region and Category

Cell	Value
A1	Region
B1	Category
C1	Sales
A2	East
B2	Furniture
C2	1000
A3	East
B3	Office Supplies
C3	500
A4	West
B4	Furniture
C4	700
A5	West
B5	Technology
C5	1200

Formula Trace

SUM(Sales) with Detail Level = Region

Step 1: Group data by Region

Step 2: Sum Sales for East group

Step 3: Sum Sales for West group

Step 4: Display sums by Region

Cell Reference Map

    A       B               C
1 |Region | Category      | Sales
2 | East  | Furniture    | 1000
3 | East  | Office Supplies | 500
4 | West  | Furniture    | 700
5 | West  | Technology   | 1200

Arrows: Sales values summed grouped by Region (A column)

Sales values in column C are grouped by Region in column A for summing

Result

Region | Total Sales
--------------------
East   | 1500
West   | 1900

The result shows total sales summed for each Region, ignoring Category detail

Sheet Trace Quiz - 3 Questions

What is the total sales for the East region when detail level is Region?

A 1000

B 1500

C 500

D 2500

Key Result

SUM aggregation groups data by specified detail level fields before summing