You can just hide all the previous months (select month names in the view and right-click -> Hide). They would still be there, allowing table calc to work, but will not be visible.

Thanks for the tip.  This is actually good to know.  Sorry for the additional ask, but when you hide the dates, you make them "unselectable" in the Quick Filters.  I was hoping to make the date selection dynamic, yet allow for a Month-over-Month and Year-over-Year pull.  For example, if I want to select a criteria for March-11, it will give me Month-over-Month and Year-over-Year for that particular month.

Brent,

how would you define YoY and MoM?

One of them is the "same month previous year" - what is the other one, and which is which, as applied to a single month? Is it the "previous month same year"?

Brent,

have a look at the sample workbook attached - does it solve your problem?

The solution involves table calculations, parameters and column/row hiding. Post here if you need detailed instructions.

Hi Dimitri,

Could you tell me how to get the last step of your solution (final tab) so that all the other months aren't visible?

Thank you!

Allison, Dimitri is asleep right now, so I'll jump in:

Repeat for the MONTH(Date) pill.

Hope this helps.

--Shawn

Ah thank you!! I would've never thought to do that

Yeah, it would be nice if there were some sort of visual cue on the pill. You can tell when something is being hidden by clicking the triangle and looking for "Show Hidden Data". So if you see something like this in the future, check for that first. And now you know how to do it yourself! (Gotta love the forums.)

Cheers,

--Shawn

This was an amazingly useful approach to me!

I had to show only a running sum of a value, and yet display it only up to the month defined by a date parameter (and be able to see the progression as I moved a slider).

Thanks a lot, Shawn Wallwork! Shouldn't this be marked as the right answer?

I'm using the LOOKUP function to go 12 months back and getting the difference between this month and that one, but I show all the months. so I've manually hidden the months I don't want, but sometimes people put data in the system for a month i haven't selected to hide, so it shows up.

is there an additional filter i can put on the worksheet to hide all month except this current month, but still keep the calculation? or would i have to change the calculation?