Aggr(SUM(Amount), group)

[wanyunyang]

Hi guys,

I have a silly question: what is the difference between

SUM(Aggr(SUM(Amount), group))

and

Aggr(SUM(Amount), group)?

Thanks in advance!

[fabdulazeez · Accepted solution]

Aggr(SUM(Amount), group)  ----- Gives a virtual table with sum of amount for each groups.so this could be dimension

SUM(Aggr(SUM(Amount), group)) -- Gives the sum of all amounts