Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to Calculate Sum with Distinct dimension in script?
Looking for a script function equivalent to =sum( Aggr([Sales Price ], LineItemId))
Thanks
You would do something like this:
LOAD LineItemId,
Sum([Sales Price]) as Sum
Resident XYZ
Group By LineItemId;
create a filed as
sum([sales prcie]) as sum