Select last 3 quarters

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

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

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,

Re: Select last 3 quarters

jagan — Fri, 20 Sep 2013 14:49:00 GMT

Hi,

Try this

=Sum({<oDate={'>=$(=QuarterStart(Today(), -3))<=$(=QuarterEnd(Today(), -1))'}>} Sales )

Hope this helps you.

Regards,

Jagan.