How to display current,previous,next month without any selection...!!

[#1]

I want to display current month,previous month,next month and Previous to previous Month.

Eg: SEPT(Previous to Previous)

       OCT(Previous Month)

        NOV(Current Month)

         DEC(Next Month)

Note:Without any Selection,I want the following requirement to display on my chart.

[ychaitanya]

Try This

Sum({<OrderDate = {">=$(=MonthStart(Today(),-2))<=$(=MonthStart(Today(),+1))"}>}Sales)

Thanks

Chaitanya

[MK_QSL]

Current Month

=Month(Today())

Previous Month

=Month(AddMonths(Today(),-1))

Previous to Previous Month

=Month(AddMonths(Today(),-2))

Next Month

=Month(AddMonths(Today(),1))

[#4]

not Working

[annafuksa1]

Can you post you app ?

please try

Sum({<{$<Month = {$(=Max(Month)-1)}>}>}Sales) for previous month

Anna

[goncalo_ricardo_pereira]

Hello,

You can try this expressions:

Current Month

sum({$<Month = {"$(=Month(Today()))"}, Year = {"$(=Year(Today()))"}>} Sales)

Previous Month

sum({$<Month = {"$(=Month(AddMonths(Today(),-1)))"}, Year = {"$(=Year(AddMonths(Today(),-1)))"}>} Sales)

Previous to Previous Month

Sum({$<Month = {"$(=Month(AddMonths(Today(),-2)))"}, Year = {"$(=Year(AddMonths(Today(),-2)))"}>} Sales)

Next Month

sum({$<Month = {"$(=Month(AddMonths(Today(),1)))"}, Year = {"$(=Year(AddMonths(Today(),1)))"}>} Sales)

Hope it helps.