Fixed Tableau Calculation

FIXED [Dimension1], [Dimension2] : AGGREGATE([Measure])

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. fixed tableau calculation

FIXED MONTH([Date]) : AVG([Sales]) → Monthly average appears on every day row. Then compute: AVG([Daily Sales]) - [Monthly Avg] . IF [Customer Total Sales] > 10000 THEN "High

IF [Customer Total Sales] > 10000 THEN "High Value" ELSE "Standard" END IF [Customer Total Sales] &gt

Suppose you have a dataset with a category dimension and a sales measure. You want to rank the categories by sales, while fixing the category dimension.

| Expression | What it does | Best for | |------------|--------------|-----------| | | Ignores current view dimensions | Row-level comparisons, cohort tagging | | INCLUDE | Adds dimensions to the aggregation | “Show sales by region AND product” | | EXCLUDE | Removes dimensions from the aggregation | “Remove month to get quarterly total” |