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,

[jduluc12]

I checked the sample and it was not working.

i am not sure if it is Qlikview version issue.

[sunny_talwar]

May be this

Sum({<Cust = {"=product = 'Prod_1' "}>}Amount)