rolling QTD for selected period

[srujanaponnuru]

Hi All,

i have a requirement as below:

I have QTD dates as :

20200301

20200601

20200901

20201201

in my Monthyear filter i am selecting Dec-2020 and i have written rolling QTD calculation as below in set analysis:

Datenum = {">=$(=num(date(monthstart(quarterend(max(MonthYear)),-6)))) < = $(=num(date(monthstart(quarterend(max(MonthYear))))))"} 

my output is coming as:

DEc-2020`

Nov-2020

Oct-2020

Sep-2020

Aug-2020

Jul-2020

Jun-2020  But i don't want all the months:  i need my output to come when i select monthyear filter Dec 2020 Dec 2020 Sep -2020 Jun-2020   i need only above months to come in my output. please suggest.

[MayilVahanan]

HI @srujanaponnuru 

Try like below

Datenum = {'$(=num(date(monthstart(max(MonthYear),-6))))','$(=num(date(monthstart(max(MonthYear),-3))))',

'$(=num(date(monthstart(max(MonthYear)))))'} 

Hope it helps.

Check the brackets once