how to calculate last 6 months and next 6 months sales based on my selection?

[gkcchowdary]

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

[sunny_talwar]

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)

[Anonymous]

Hi

Try this 

=Sum({<Date={">=$(=MonthStart(Max(Date),-5))<=$(=MonthEnd(Max(Date),+6))"}>} Sales )

[Anonymous]

Hi,

Please see attached QVW. !