Displaying YTD Bar chart based on month selected in list box

[#1]

Hi All,

I have qvw with Dimensions as Month & Year in list boxes for selection. Sales is a measure which needs to be measured across month in a bar chart. How to write a code so that if some one selects " April" in the Month list box, the bar chart shows 4 bar's each for Jan, Feb, Mar & Apr?  Similarly for other months.

Currently, if I select the month in the list box, it shows only one bar , for that month only.

All help will be greatly appreciated.

Thanks,

Tutan

[Gysbert_Wassenaar]

See attached example. The expression sum({<Month={"<=$(=max(Month))"}>}Sales) is doing the work by picking the months smaller than the maximum of the selected months. For YTD you also need to select a year.