Dashboard Mode - EXCLUDE LOD expression
Business Question
How much total sales did each product category make, ignoring the sales differences by region?
How much total sales did each product category make, ignoring the sales differences by region?
| Order ID | Product Category | Region | Sales |
|---|---|---|---|
| 1001 | Furniture | East | 200 |
| 1002 | Furniture | West | 150 |
| 1003 | Technology | East | 300 |
| 1004 | Technology | West | 250 |
| 1005 | Office Supplies | East | 100 |
| 1006 | Office Supplies | West | 120 |
SUM([Sales])
{EXCLUDE [Region] : SUM([Sales])}
+----------------------+---------------------------+
| KPI: Total Sales | Bar Chart: Sales by Cat & Region |
| (Top Left) | (Top Right) |
+----------------------+---------------------------+
| Bar Chart: Sales by Category (Exclude Region) |
| (Bottom Left) |
+-------------------------------------------------------+
| Table: Detailed Sales Data |
| (Bottom Right) |
+-------------------------------------------------------+
Filters on Product Category and Region allow users to select specific categories or regions.
If you add a filter to show only Region = East, which components update their values?
EXCLUDE LOD expression do in Tableau?[Region] and [Category], what does this expression return?{EXCLUDE [Category] : SUM([Sales])}{EXCLUDE [Region] : SUM([Profit])}[Region], [Category], and [Sub-Category]. You want to see total sales by Region only, ignoring Category and Sub-Category. Which EXCLUDE LOD expression achieves this?Pass the test and this pattern moves unknown