Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
i need only above months to come in my output. please suggest.
|
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