Set Analysis

[#1]

Hi,

Below is the requirement :[Data is vaialble in attachment]

1) Find count of members using P1 and P2 but not P3 by region

Dimension: Region

Expression: Count({ 10

Thanks

Ramesh

[sivarajs]

Dimension: if(Region<>P3,Region)

Exp:count( distinct members)

or

Dimension: Region

Exp:count({Region-={'P3'}}members)

[#3]

Member	Region	Purchase Date	Product	Visits	Quantity	Category
A	R1	07/16/13	P1	1	30	C1
B	R2	07/15/13	P1	2	40	C2
A	R1	07/01/13	P2	0	10	C1
A	R3	07/16/13	P1	3	10	C2

1.   Find count of members using P1 and P2 but not P3 by region 

   Dimension: Region

   Expression: Count({<Member = p({<Product={P1}>}Member)*p({<Product={P2,P3}>}Member)>}Member)

Condition: A member might have bought products from different regions, but you have to consider a member for only one region based on max date of P2

2.   Find the count of members for region who bought: 

   IF P1 – member visits >=2 and cumulative sum of quantity across a category greater than 90

   IF P2 – member visits >=2 and quantity > 10

Sorry.. I missed in previous post

Thanks

Ramesh

[#4]

1) I have to find members using P1 and P2 and not using P3 , which will help me to suggest P3 for members.

2) how to find sum of Quantity by Category per member by Region

thanks Sivaraj for your reply.