LOD vs table calculations in Tableau - Formula Comparison Trace

Sample Data

Sales data by Region and Category

Cell	Value
A1	Region
B1	Category
C1	Sales
A2	East
B2	Furniture
C2	100
A3	East
B3	Office Supplies
C3	200
A4	West
B4	Furniture
C4	300
A5	West
B5	Office Supplies
C5	400

Formula Trace

{FIXED [Region] : SUM([Sales])} vs WINDOW_SUM(SUM([Sales]))

Step 1: SUM([Sales]) for each row

Step 2: {FIXED [Region] : SUM([Sales])} for East

Step 3: {FIXED [Region] : SUM([Sales])} for West

Step 4: WINDOW_SUM(SUM([Sales])) over all rows

Step 5: Compare LOD and Table Calculation results per row

Cell Reference Map

    A       B               C
1 |Region | Category      | Sales
2 | East  | Furniture    | 100  
3 | East  | Office Supplies | 200  
4 | West  | Furniture    | 300  
5 | West  | Office Supplies | 400  

Arrows:
- LOD references Region and Sales columns
- WINDOW_SUM references Sales column over all rows

The formula uses Region and Sales columns for LOD and Sales column for table calculation

Result

    A       B               C       D                 E
1 |Region | Category      | Sales | LOD Sales by Region | WINDOW_SUM Sales
2 | East  | Furniture    | 100   | 300                | 1000
3 | East  | Office Supplies | 200   | 300                | 1000
4 | West  | Furniture    | 300   | 700                | 1000
5 | West  | Office Supplies | 400   | 700                | 1000

Column D shows LOD calculation fixed by Region summing sales per region. Column E shows table calculation summing all sales over the table.

Sheet Trace Quiz - 3 Questions

What does the LOD expression {FIXED [Region] : SUM([Sales])} calculate?

A Sum of sales for all rows in the table

B Average sales per category

C Sum of sales for each region ignoring other dimensions

D Sum of sales only for the first row

Key Result

LOD expressions fix aggregation at specified dimension(s); table calculations compute over the visible data in the view.