Show all preceding months

[#1]

Hi,

   I need to shoe all preceding months  from the start of the year and current month sales when a month is selected. Eg, If Apr-2011 is selected,  we should dsiplay Jan-2011,Feb-2011,Mar-2011 and Apr-2011. Any help is appreciated. Thanks.

[CELAMBARASAN]

Hi

     Sum({<Year={$(=Max(Year))},Date={"<=$(=vCurrentDate)"}>} Sales)

Hope this helps

Celambarasan

[jagan]

Hi,

Try this

Sum({<Year={$(=Max(Year))}, Month=, Date={"<=$(=Max(DateField))"}>} Sales)

Hope this helps you.

Regards,

Jagan.

[#4]

Hi!

Try This,

PFA for Help.

Expression: Sum({<MonthYear,Date=, Year=,MonthNo.={$(vtest)}>}Sales)

vtest=concat({1<MonthNo.={">=1<=$(=max(MonthNo.))"}>} distinct MonthNo.,',')

Dimension:MonthYear