pivot table rolling 12 month filter?

R

Randy Suggs

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!
 
B

Bernie Deitrick

Randy,

I would think that you could form your query to only return 12 months of
data - I don't use data cubes, so I'm just making an educated guess. Or you
could group your data in your pivot table by date and set the start date for
grouping as 6 or 12 months ago...

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rolling 12 month date filter for pivot table? 2
2003 Pivot Table Filter (items dropped in the Page Fields) 1
Pivot Table 2
Pivot Table Duplicate January 2
12 month pivot table 16
date filter in a pivot table 1
Excel Pivot Table VB Code 1
XL2007: Pivot table date filter 1

Top