Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dimension: if(Region<>P3,Region)
Exp:count( distinct members)
or
Dimension: Region
Exp:count({Region-={'P3'}}members)
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 |
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
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
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.