I want Rolling12YTD based on current date

[#1]

Hi i have i need to display Rolling12YTD  in list box based on current date.

format should be YYYY-MMM

[ashfaq_haseeb]

Hi Sanjeev,

Try this

Sum({<DATE={">=$(=MonthStart(Max(DATE),-12)) <=$(=MonthEnd(Max(DATE)))"}>} SALES)

Regards

ASHFAQ

[#3]

here it won't display list of values .it will show sum of listed values.

How can i represents in list box?

[#4]

i don't want sum

[ashfaq_haseeb]

Hi,

Can is explain what are you trying to achieve here?

Provide sample data and expected output.

Regards

ASHFAQ