To flag orders with sales higher than the regional average, the correct calculated field would compare the sum of sales for each order against the average sales of all orders within the same region:
* Correct Formula:{ FIXED [Order ID] : SUM([Sales]) } > { FIXED [Region] : AVG({ FIXED
[Order ID] : SUM([Sales]) }) }
* This calculation uses a Level of Detail (LOD) expression:
* The left part of the formula{ FIXED [Order ID] : SUM([Sales]) }calculates the total sales for each individual order.
* The right part{ FIXED [Region] : AVG({ FIXED [Order ID] : SUM([Sales]) }) }calculates the average sales per order within each region.
* The>operator is used to compare these two values to determine if the sales for each order exceed the regional average.
ReferencesThis formula utilizes Tableau's LOD expressions to perform complex comparisons across different dimensions of the data, as explained in Tableau's official training materials on LOD calculations.