Is there a way to add a rolling 12 month date filter for 'last 12 months' to
a pivot table? I see how to add conditional filters like last year, last
month, etc., but I need a way to filter for 'last 12 months' (or even last 6)
so that I don't have to update the date filter every month. This pivot table
is for manufacturing production
data and is connected to an analysis services data cube. I'm using excel
2007. Thanks for any help!