Last Month, Last 2 Month and so on filter

[#1]

Hi,

I have a requirement. Say in my sheet, there will be LED Gauges, different charts which will show data for the current month. Now, I will have 3 buttons at the bottom. 'Current Month', 'Last Month', 'Last 2 Month'. Whenever the user clicks on Last Month, the data in all the charts and gauges changes according to the Last Month and same will happen for the 'Last 2 Month'.

If there will be three months, NOV '10, DEC '10, JAN '11 and assuming JAN to be the current month, then when user click on LAST Month, only DEC '10 data will get filter and when user clicks on 'Last 2 Month' only NOV '10 data will get filter.

Please tell me how to achieve the same.

Thanks.

Regards,

Sachin A.

[SunilChauhan]

Please see the attached file

hope this will work for u

[#3]

Integrated Successfully.

Thanks a lot again.

@ Sunil, nice thanks. will keep this as a reference.

Thanks all.