set analysis for How to show every 3rd month sale

[vikasmahajan]

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

[PrashantSangle]

Hi,

you can create flag for every three month in back-end. Then use that flag in your set analysis.

Regards,

Prashant Sangle

[BrunPierre]

@vikasmahajan Check out the solution on this thread;

How to get three months 

[vikasmahajan]

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