Set analysis question

[jduluc12]

Hi,

I got this data set

Cust      product           Amount

A              Prod_1          10

A              Prod_2          20

B              Prod_1          20

C              Prod_1          30

C              Prod_3            10

I need to write an expression where it sums the amount for only that customer which has only Prod_1.

For Example

It should consider only Cust B because both A and C have others product too .

Thanks,

[vishsaggi]

What is your expected output? You want to see only B cust in your table?

[jduluc12]

Yes that is right

[its_anandrjs]

In expression write

=count({<Cust={"=count(distinct product)=1"}>}Distinct Amount)

[its_anandrjs]

Sorry this is right one try

=Sum({<Cust={"=count(distinct product)=1"}>}Distinct Amount)

[its_anandrjs]

Or even this is right one

=Sum({<Cust={"=count(distinct product)=1"}>} Amount)

Dear Jean do you have confusion on the output that shown to you let me know about this.

[antoniotiman]

Hi Jean,

may be this

Sum({<Cust=E({<product-={Prod_1}>})>} Amount)

Regards,

Antonio

[its_anandrjs]

Another way is you can achieve the same in the script part by find out the frequency of the product count.

Source:

LOAD * INLINE [

    Cust, product, Amount

    A, Prod_1, 10

    A, Prod_2, 20

    B, Prod_1, 20

    C, Prod_1, 30

    C, Prod_3, 10

];

ProdFrq:

Left Join

LOAD

Cust,

Count(product) as CountProd

Resident Source

Group By Cust;

NoConcatenate

LOAD * Resident Source Where CountProd = 1;

DROP Table Source;

[jduluc12]

It is not working

[its_anandrjs]

Can you share some sample for this or can you check my sample on top on that it is working.