FIXED LOD expression 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	100
A3	East
B3	Technology
C3	200
A4	West
B4	Furniture
C4	150
A5	West
B5	Technology
C5	300

Formula Trace

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

Step 1: SUM([Sales]) for Region = 'East'

Step 2: SUM([Sales]) for Region = 'West'

Step 3: {FIXED [Region] : SUM([Sales])} returns 300 for East, 450 for West

Cell Reference Map

    A       B          C
1 |Region |Category | Sales
2 | East  |Furniture|  100
3 | East  |Technology| 200
4 | West  |Furniture|  150
5 | West  |Technology| 300

Arrows: Sales values summed grouped by Region

Formula uses Sales values grouped by Region ignoring Category

Result

    A       B          C          D
1 |Region |Category | Sales | Fixed LOD Sales
2 | East  |Furniture|  100  | 300
3 | East  |Technology| 200  | 300
4 | West  |Furniture|  150  | 450
5 | West  |Technology| 300  | 450

Fixed LOD Sales shows total sales per Region repeated for each row in that Region

Sheet Trace Quiz - 3 Questions

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

A Sum of Sales for all data ignoring Region and Category

B Sum of Sales for each Region ignoring Category

C Sum of Sales for each Category ignoring Region

D Average Sales per Region

Key Result

FIXED LOD calculates an aggregation fixed by specified dimension(s) ignoring other filters