FIXED [Customer Name] : SUM([Sales]) Name it [Customer Total Sales] .
– You can now color by customer segment, filter to high-value customers, or show average discount per segment. It works everywhere. fixed tableau calculation
// 2. Gap to Regional Leader SUM([Sales]) - MAX([Max Sales per Region]) FIXED [Customer Name] : SUM([Sales]) Name it [Customer
You want to know what percentage of total sales a specific sub-category contributes, but you want the denominator (Total Sales) to remain fixed even if you filter the view. filter to high-value customers
FIXED MONTH([Date]) : AVG([Sales]) → Monthly average appears on every day row. Then compute: AVG([Daily Sales]) - [Monthly Avg] .