Jump to Dashboard and Past Month/Quarter/Year

[Drichardson]

I need to be able to jump to a dashboard with either the current date or the past date data, depending on which column was clicked.

I have a pivot with both the current and past quarter values, and if someone launches the jump to from the past quarter value I'd need to see the data filtered at that past quarter. Is there anyway to accomplish this?

[Drichardson]

Example, if user set the below dashboard to 8/2012 as the month, when they click on Current Qtr Cost I want the data to be filtered to 8/2012 for the Jump To. If they click on Past Qtr Cost, that filter would need to show 5/2012.