Hi, I'm trying to create a graphic that shows me the status of a client's sale.
I need to know when a customer changes status "A" to "C" from one month to the next.
For example: January 500 customers with "A" status February Of the 500 clients of the month of January, 100 clients changed to "B" status.
Dimension:
=if([CSMO_ACTUAL] = 0 and [CSMO_ANT]= 0,'A', if([CSMO_ACTUAL] = 0 , 'B',
if(CSMO_ACTUAL-(CSMO_ANT)>0,'C','D')))
Expression
COUNT({<[FECHA_TEMP.autoCalendar.Year]={'$(vMaxYear)'}, [FECHA_TEMP.autoCalendar.Month]={'$(vMaxMonth)'},
[FECHA_TEMP.autoCalendar.Day]={'<=$(vMaxDay)'},
FECHA_TEMP=,[FECHA_TEMP.autoCalendar.YearMonth]=>}ID)
I hope u can help me 🙂
