Problem with set analysis

[ecabanas]

Hi Guys,

I wnat to create a table with the following formula:

    - I want to show the customers that did not buy in the selected month and bought in the previously (Lost). In the file attache if you select April the RED table has to show the following records in red: C000005, C000006 and C000008

CustomerID	Date	Salesid
C000001	31/01/2015	A
C000002	31/01/2015	B
C000003	31/01/2015	C
C000004	31/01/2015	D
C000001	28/02/2015	E
C000002	28/02/2015	F
C000005	28/02/2015	G
C000006	28/02/2015	H
C000005	31/03/2015	I
C000006	31/03/2015	J
C000007	31/03/2015	K
C000008	31/03/2015	L
C000007	30/04/2015	K
C000009	30/04/2015	M

Many thank's guys

Eduard

[rubenmarin · Accepted solution]

Hi Eduard, the selection in month is messing with your expression, ignore selections in months:

count({<MonthIndex={'$(VPriorMonth)'},CustomerID=E({<MonthIndex={'$(VCurrentMonth)'}>}CustomerID), CalendarMonthName>} distinct CustomerID)

[ecabanas]

Many thank's Ruben