FIXED LOD expression in Tableau - Dashboard Guide

Dashboard Mode - FIXED LOD expression

Business Question

How can we calculate the total sales per region regardless of other filters, and compare it with the filtered sales?

Sample Data

Order ID	Region	Category	Sales
1001	East	Furniture	200
1002	West	Technology	450
1003	East	Office Supplies	150
1004	South	Furniture	300
1005	West	Office Supplies	100
1006	South	Technology	500
1007	East	Technology	350

Dashboard Components

• KPI Card: Total Sales (Filtered)
  Shows the sum of sales based on current filters.
  Formula: SUM([Sales])
  Example Result: If Region filter is East, result is 700 (200+150+350)
• KPI Card: Total Sales per Region (Fixed LOD)
  Shows total sales per region ignoring other filters.
  Formula: {FIXED [Region]: SUM([Sales])}
  Example Result: For East region, result is 700; for West, 550; for South, 800
• Bar Chart: Sales by Category
  Displays sales sum by category, affected by filters.
  Formula: SUM([Sales]) grouped by [Category]
• Table: Sales Details
  Shows detailed sales data rows, filtered by user selections.
  Columns: Order ID, Region, Category, Sales

Dashboard Layout

+----------------------+--------------------------+
| Total Sales (Filtered) | Total Sales per Region    |
|        [700]          | (Fixed LOD) [700 East]    |
+----------------------+--------------------------+
|                          Bar Chart: Sales by Category           |
|               (Furniture, Technology, Office Supplies)          |
+---------------------------------------------------------------+
|                          Table: Sales Details                   |
|               (Order ID, Region, Category, Sales)              |
+---------------------------------------------------------------+

Interactivity

User can select Region or Category filters.

• Total Sales (Filtered) updates based on filters.
• Bar Chart updates to show sales by category for filtered data.
• Sales Details Table shows only rows matching filters.
• Total Sales per Region (Fixed LOD) remains fixed per region ignoring other filters except Region filter itself (if applied).

Self Check

If you add a filter for Region = West, which components update and what are their new values?

• Total Sales (Filtered): Updates to 550 (450 + 100)
• Bar Chart: Shows sales by category for West region only.
• Sales Details Table: Shows only orders 1002 and 1005.
• Total Sales per Region (Fixed LOD): Shows 550 for West region (fixed total sales for West).

Key Result

Dashboard shows total sales filtered vs fixed per region, sales by category, and detailed sales data.