Aggr by calculated field

[maxsheva]

Hi,

I need to aggregate values by two dimensions where one of them is calculated.

Is it possible to create?

LOAD * Inline [

GroupName, Value

Group1, 100

Group1, 300

Group2, 500

Group2, 900

Group2, 150

];

Expression is

Aggr(Sum(Value),GroupName

,if(Value<=100,1,if(Value<=500,2,3))

)

[antoniotiman]

Is it really true.

Regards,

Antonio

[maxsheva]

Antonio,

Do you have a suggestion if Count(Value1) firts?

Something like this Sum(Count( distinct Value1)*Value2)