Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need set analysis for how to show every 3rd month sales in attached format: I have calendar created in my model.
thanks
Vikas
Hi,
you can create flag for every three month in back-end. Then use that flag in your set analysis.
Regards,
Prashant Sangle
@vikasmahajan Check out the solution on this thread;
Hi All,
Thanks for your reply I resolved with creating variables
If you do it with variables, you should have
v_MaxDate = Max(TempDate);
That should give you the maximum available date
v_CALENDAR_Month_3MRolling = Only({< TransactionDate={'$(v_MaxDate)'}>} CALENDAR_Month_3MRolling)
That should give you the related value of CALENDAR_Month_3MRolling (1, 2 or 3) for the month of the maximum available date
So your measure is sth like
Sum({<Flag_Rolling3Months = {1},CALENDAR_Month_3MRolling = {'$(=$(v_CALENDAR_Month_3MRolling) )'}>} Sales_Dollars)
Vikas