Future Dates

Zara — Wed, 31 Mar 2021 16:15:06 GMT

Afternoon all,

Have a report where the user will go in and select any year month and i want to do a count of any sales from that month and the subsequent 3 months only from that date.

I've tried to replicate in the picture below

So if the user selected -

Jan 2020 - I would expect the sum to be 166

Feb 2020 - i would expect the sum to be 191

March 2020 - i would expect the sum to be 172

Anyone have any ideas what i would need to put within my set analysis to be able to achieve this please.

Thank you in advance, i love the monthsago field, i suppose i'm looking for the opposite.

Thanks

Re: Future Dates

Anil_Babu_Samineni — Wed, 31 Mar 2021 17:20:09 GMT

Perhaps this?

Sum(Aggr(If(GetselectedCount(SalesYearMonth)>1, Sum({<SalesYearMonth={">=$(=Max()SalesYearMonth)<=$(=AddMonths(Max(SalesYearMonth),3))"}>}SumSales), Sum(SumSales)), SalesYearMonth))

topic Re: Future Dates in App Development

Future Dates

Re: Future Dates