sale issue

[#1]

Scenario

Purchased

   customer who bought the product a

customer id   product id

1                     1

1                     4

2                     2

3                     4

Product id  Product

1                     a

2                     b

3                     a

4                     c

not Purchases

   customer who had not bot the product b

Product id  Product

1                     a

2                     b

3                     a

4                     c

1. i need customer who had not purchase the product b and customer who purchased product a, i am having two set analytics group called NOTPurchase and Purchase.

I am using the following formula to find the solution.

sum({<CustId-={"[NOTPurchase]::CustId"},CustId=[Purchase]::CustId>}saletotal)

[PrashantSangle]

Hi,

Please find attached apps.

Might be as per your requirement.

Regards

[#3]

Thanks max, But i need to implement with the set analytics only. product 1 listbox should not link with with product 2 list box. but both data are getting from the same table

product 1 table <Purchase >(Set Analytics)

product 2 table <NotPurchase >(Set Analytics)

[jyothish8807]

Hi Srini,

May it work;

Purchase:
LOAD * INLINE [
Customerid,Productid
1,1
1,4
2,2
3,4
];

Product:
LOAD * INLINE [
Productid,Product
1,a
2,b
3,a
4,c
];

NoConcatenate
TestPurchase:
Load * Resident Purchase;

join
load * Resident Product
where Product = 'a' and  Product <> 'b';

DROP Tables Purchase,Product;

Regards

KC

[#5]

I am getting these two tables from the database. all these selection are dynamic. user want  to see the customers who purchased one project and not purchased other product, say for example  consider the soap park avenue green purchased by set of customers and park avenue blue not purchased by the customers.