Rolling 24 months static

[vardhancse]

Hi,

Have one requirement is that, need to create one trend

it should be statis 24 months based on the selected year-23 months

given expression as below:

Sum

Sum({<FiscalYear={$(=Max(FiscalYear)),$(=Max(FiscalYear)-1)},MonthName=,Metric={'Enablement Cost (A$m)'}>}Sales)

now i am getting static 24 months trend based on the selected year.

but have one issue is that, the trend was showing only for the data available.

Requirement is that, data available or not the months should display.

can please help me out.

[JonnyPoole]

Do you have any other date related fields in your application that may be narrowing the time span ?  For example below, you may need to cancel out other selections that are date related. 

Sum({<FiscalYear={$(=Max(FiscalYear)),$(=Max(FiscalYear)-1)},MonthName=,Date=,Quarter=,Metric={'Enablement Cost (A$m)'}>}Sales)

If you clear selections does it work as you want ?

[vardhancse]

Hi,

Thanks for your reply.

in the line chart, given dim was fymonth(jan-13,feb-13.....)

and in the expression :

Sum({<FiscalYear={$(=Max(FiscalYear)),$(=Max(FiscalYear)-1)},MonthName=,Metric={'Enablement Cost (A$m)'}>}Sales)

tried adding the other date fields, but till which month data was there, the trend was showing till there only.

[JonnyPoole]

Ok. i don't see any change to your expression so i'm not sure what you tried ?

Also you mentioned the dimension is 'fymonth'. If that is the field name then that is an example of a field that should be canceled out in the SET ANALYSIS like below:

Sum({<FiscalYear={$(=Max(FiscalYear)),$(=Max(FiscalYear)-1)},fymonth=,MonthName=,Metric={'Enablement Cost (A$m)'}>}Sales)

I also didn't get a response on whether this works fine if you clear the selections.  Can you share that ?

[vardhancse]

hi,

Let me try once and will get back to you.

Thank you