Cumulative sum to selected month

[#1]

Hi, I've a problem with a cumulative sum which i have to display in the text box

What i have is a listbox with short month names, for example Jan, Feb, Mar, Apr

I have some data about Sales.

What i need is to sum my sales cumulative in all the months TO the selected, if user selects march, sum is based on january, february and march etc.

How to do this? =Sum({$<Month={"<$(=????"}>}Sales)

[MayilVahanan]

Hi

If u have date field, then u can use

=Sum({$<DateField={">=$(=YearStart(Max(DateField))) <= $(=MonthEnd(Max(DateField)))"} , MonthField =>}Sales)

hope it helps

[#3]

I dont have:/

The only data i have is a filter with this short month names and this text box. I need to show in this text box entire cumulative sum of sales in period of time limited by month selected by user