Selected Month - Previous Month

[#1]

Hi

    I have data from 2007 to 2012,  whenver i will select any month from any year i want update the sheet with selected month and previous month....so how can we use the set analysis here...

[jagan]

Hi Anil,

Check this expressions

For Previous Month

=Sum({<Year=, Month=, DateOfService={'>=$(=MonthStart(Max(DateOfService), -1))<=$(=MonthEnd(Max(DateOfService), -1))'}>} Sales)

For Current Month

=Sum({<Month=, Year=,DateOfService={'>=$(=MonthStart(Max(DateOfService)))<=$(=Max(DateOfService))'}>} Sales)

Hope this helps you.

Regards,

Jagan.

[daveamz]

Hello,

     See the example in the file attached.

Regards,

David