Forward Cumulative sum

[QS21]

Hi all, I am trying do a forward cumulative sum. Example I have a MMMYY field and some numbers.  If current reporting month is April22, and I select jan22 from my date field, I shd see the sum of values from Jan till date. It shd be dynamic based on selection and if I want to show 1 year data in table also how can I show these s values.

[salonicdk28]

Can you please share the sample data and what are you looking for basically

Thanks,

Saloni

[vinieme12]

=Rangesum(Above(

Sum({<Date={">=$(=Date(max(Datefield),'yourdateformat'))"}>}Sales) , 0 , Rowno() ) )