SQX009 — Nested aggregation
Error — blocks saving
What happened
Section titled “What happened”An aggregation directly inside another aggregation (Sum(Avg(…))), or inside an iterator row expression (SumX(Sales, Sum(…))). Aggregation arguments — and iterator row expressions — are row-level.
How to fix it
Section titled “How to fix it”To re-aggregate per-group values, compute the inner grain with Fixed or Include and set the outer aggregation in the chart’s field well.