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?
How can we calculate the total sales per region regardless of other filters, and compare it with the filtered sales?
| 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 |
SUM([Sales]){FIXED [Region]: SUM([Sales])}SUM([Sales]) grouped by [Category]+----------------------+--------------------------+ | 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) | +---------------------------------------------------------------+
User can select Region or Category filters.
If you add a filter for Region = West, which components update and what are their new values?
FIXED LOD expression do in Tableau?{FIXED [Dimension]: AGG([Measure])}.{FIXED [Region]: SUM([Sales])} matches syntax exactly. The other options have invalid syntax like misplaced braces, missing colons, or use INCLUDE instead of FIXED.{FIXED [Category]: SUM([Sales])} when placed on a view filtered to only show 'Furniture' products?{FIXED [Region] SUM([Profit])}Pass the test and this pattern moves unknown