Simple Last 3 Months sale set Expression

[zahidrahim_ocp]

Dear Experts,

I am trying to get last 3 months sale but getting only the date selected one day sale. i am using below expression:

SUM({<TRX_DATE = {"$(='>=' & v3MonthsBackDate)"}>}

(IF (TYPE = 'CM', QUANTITY_CREDITED , QUANTITY_INVOICED)/ IF(isnull(LTR_CV_RATE),1,LTR_CV_RATE))

)

where v3MonthsBackDate is a variable with below syntax:

=(ADDMONTHS(Max(TRX_DATE),-3))

Regards,

Zahid Rahim

[zahidrahim_ocp]

Dear Sunny,

I have manage to fix it by introducing a Master Calendar which is an independent table not joined with existing data model and then use the calendar date in filter.

Please inform is this good approach?

Regards,

Zahid Rahim

[sunny_talwar]

If it isn't slowing down you app, I would say you can use it... but ideally, it is not a good idea to have an island table drive your charts as it forms a Cartesian Product with your data slowing down your app... If you don't see the slowing down, then you should be fine