Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
It simply means that you cannot nest aggregation function calls (only one exception: if you put a call to Aggr() between them. Aggr() sort-of un-aggregates values)
For example, this is illegal syntax:
=Avg(Sum(SalesAmount))
whatever the dimensions in your table. But this isn't:
=Avg(Aggr(Sum(SalesAmount), Customer, Year))
Best,
Peter
try to read this post
It simply means that you cannot nest aggregation function calls (only one exception: if you put a call to Aggr() between them. Aggr() sort-of un-aggregates values)
For example, this is illegal syntax:
=Avg(Sum(SalesAmount))
whatever the dimensions in your table. But this isn't:
=Avg(Aggr(Sum(SalesAmount), Customer, Year))
Best,
Peter