1 Reply Latest reply: Sep 20, 2013 10:49 AM by jagan mohan rao appala RSS

    Select last 3 quarters

    Vladimir Kostochka

      Hi guys,

      I need to select last 3 quarters.

      I load the variable

      dual(QuarterName(QuarterStart(date)),QuarterName(QuarterStart(date))) as QYYYY

      The result is below

      Capture.JPG.jpg

      In expression I use set analysis

      {<QYYYY={">=$(=QuarterName(QuarterStart(max(QYYYY))-100)"},AAA={1}>}

       

      Should I use only on date level like my week selection?

      {<oDate={">=$(=Date(WeekStart(date(today()))-84))"}

       

      Thanks,