Select last 3 quarters

[Anonymous]

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,

[jagan · Accepted solution]

Hi,

Try this

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

Hope this helps you.

Regards,

Jagan.