Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have simple requirement if i select any month i want display last 6 month sales.
Ex:if i select march i want dislpay last 6 month sales like oct,nov,dec,jan,feb and mar.sales i want show. how to write the set expression.
same way if i select any month i want display next 6 month sales.
Ex: If i select June than display june,july ----up to Nov.
Thanks
chaitu
May be this
Last 6 months
Sum({<Date = {"$(='>=' & Date(MonthStart(Max(Date), -6), 'DateFieldFormatHere') & '<=' & Date(Max(Date), 'DateFieldFormatHere'))"}, Month, Year, MonthYear>}Sales)
Next 6 months
Sum({<Date = {"$(='>=' & Date(Max(Date), 'DateFieldFormatHere') & '<=' & Date(MonthStart(Max(Date), 7) - 1, 'DateFieldFormatHere'))"}, Month, Year, MonthYear>}Sales)
Hi
Try this
=Sum({<Date={">=$(=MonthStart(Max(Date),-5))<=$(=MonthEnd(Max(Date),+6))"}>} Sales )
Hi,
Please see attached QVW. !