Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Hi,
Try this
=Sum({<oDate={'>=$(=QuarterStart(Today(), -3))<=$(=QuarterEnd(Today(), -1))'}>} Sales )
Hope this helps you.
Regards,
Jagan.
Hi,
Try this
=Sum({<oDate={'>=$(=QuarterStart(Today(), -3))<=$(=QuarterEnd(Today(), -1))'}>} Sales )
Hope this helps you.
Regards,
Jagan.