Sum with distinct dimension in Load script

[#1]

Is it possible to Calculate Sum with Distinct dimension in script?

Looking for a script function equivalent to =sum( Aggr([Sales Price ], LineItemId))

Thanks

[sunny_talwar]

You would do something like this:

LOAD LineItemId,

          Sum([Sales Price]) as Sum

Resident XYZ

Group By LineItemId;

[Chanty4u]

create a filed as

sum([sales prcie]) as sum