How to write set analysis calculation for 1 month , 3month, 6m..

[Hariprasad]

Hi Team,

I want to know how to write set analysis for like we are in feb 2023, so  need to show what is the sales for lastmonth like jan sales and 3rd month like november 2022 and sept2022 sales

form current month to 1st, 3rd, 6th month like this

[WildmoserGeorg]

If there are fields (example 1MonthField) to flag (1 true) for the period in the mastercalendar:

sum({< 1MonthField = {1}>} *formula*)

...

[neerajthakur]

For last 1 month : Sum({<Month={"Month(AddMonths(Today(),-1))"}>}Sales)

For 3rd month : Sum({<Month={"Month(AddMonths(Today(),-3))"}>}Sales)

For 6th month : Sum({<Month={"Month(AddMonths(Today(),-6))"}>}Sales)