Alternative for Aggr()

[beck_bakytbek]

Hi Folks,

i have got a question, i use this expression on the User Interface:

Max(Aggr(Sum([Order Total]),[Customer Name], [Employee ID]))

and it does work well,

I want just know, how can i convert this expression within Script-area? And what kind of function can i use in Script-area instead of Aggr()

Thanks a lot in advance

beck

[sunny_talwar · Accepted solution]

Lets say you have a table called Fact with the three fields [Order Total], [Customer Name], [Employee ID]

Fact:

LOAD [Order Total],
           [Customer Name],

           [Employee ID],

           ....

FROM ....;

Now you can do this

Aggr:

LOAD [Customer Name],

           [Employee ID],

           Sum([Order Total]) as [Sum Order Total]

Resident Fact

Group By [Customer Name], [Employee ID];

Do you want to find the max also? If you do... you can just do this

Max:

LOAD Max([Sum Order Total]) as [Max Sum Order Total]

Resident Aggr;

[beck_bakytbek]

Sunny thanks a lot for your quick response