Need values for all Month less than the one selected in the list box

[#1]

My requirement is that, when a user selects any month in the list box, user should be able to see the sales values from Jan to selected Month in the straight table .

In my current scenario, when user selected Sep, all the values from Jan to Aug becomes Zero. Where as I want value to be displayed form Jan to sep and not just Sep

[swuehl · Accepted solution]

Try a set expression:

Sum({<MonthField = {"<=$(=max(MonthField))"}>} SalesField)

Or

Sum({<MonthField = {"=MonthField<=$(=max(MonthField))"}>} SalesField)

Replace MonthField and SalesField with your appropriate field names.

[vikasmahajan]

Hi,

WelCome

Vikas