{ FIXED : ... }: { FIXED : SUM([Sales]) } : Aggregate ignoring viz level for true total

{ FIXED [State] : ... }: { FIXED [State] : AVG([Profit]) } : State-level value regardless of view

{ INCLUDE [Product] : ... }: { INCLUDE [Product] : SUM([Sales]) } : Add finer granularity than view

{ EXCLUDE [Region] : ... }: { EXCLUDE [Region] : AVG([Sales]) } : Remove dimension from aggregation

LOD + DATE: { FIXED DATETRUNC('month',[Order Date]) : SUM([Sales]) } : Monthly totals independent of view

ATTR() with LOD: IF { FIXED : COUNTD([Customer ID]) } >100 THEN 'Large' END : Use LOD inside logical calc

FIXED & PARAM: { FIXED : SUM( IF [Segment]=[p.Segment] THEN [Sales] END ) } : Dynamic totals by parameter

LOD Nested: { FIXED [Category] : AVG( { FIXED [Sub-Category] : SUM([Sales]) } ) } : Nested LOD for meta agg

LOD Filtering: IF { EXCLUDE [Customer ID] : SUM([Sales]) } > 1000 THEN 'VIP' END : Use LOD to filter by group metrics

REFERENCE: SUM([Sales]) / { FIXED : SUM([Sales]) } : Compute percent of total