Distinct in set analysis

[wanyunyang]

I have some Orders and Amounts with duplicates:

Order Amount

A         1

A         1

B         2

C         1

I'm trying to write a function to calculate SUM(Amount) for different Orders. The result should be: 1+2+1=4. How should I do it in set analysis?

Thanks for help!

[Chanty4u]

try

LOAD Distinct * INLINE [

Pro,    Order Amount

    A, 1

    A, 1

    B, 2

    C, 1

];

[wanyunyang]

I'm not able to do this in data load script. Is it feasible in set analysis?

[Chanty4u]

looking for this?

sum(DISTINCT  [Order Amount])

[wanyunyang]

Then it will count 1 only once. 1 should be counted twice, once for A once for C.

I'm trying to find something like: SUM({<DISTINCT Order>} Amount)

[Chanty4u · Accepted solution]

try this

=sum(aggr( sum(Distinct [Order Amount]),Pro))

[sunny_talwar]

May be this

Sum(Aggr([Amount], Order))

[Anonymous]

Hi

Try below.

Table:

LOAD  * INLINE [

Pro,    Order Amount

    A, 1

    A, 1

    B, 2

    C, 1

];

FinalTable:

LOAD

[Order Amount],

Pro,

If(Pro <>Previous(Pro), 'NoDuplicate') as Flag

Resident Table;

DROP Table Table;

in front end  use :   =sum({<Flag={"NoDuplicate"}>} [Order Amount])

[sasiparupudi1]

Aggr(Sum(Amount),Order )