Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you please share the sample data and what are you looking for basically
Thanks,
Saloni
=Rangesum(Above(
Sum({<Date={">=$(=Date(max(Datefield),'yourdateformat'))"}>}Sales) , 0 , Rowno() ) )