rolling 12 month date filter for pivot table?

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 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.
 
R

Randy Suggs

Mr. Seidenber,
Thank you for your help. I tried the first solution so far. Since this pivot
table is connected to an OLAP datacube, I can't add a formula field in the
pivot table to generate the 0/1 for the filter. Regarding the second one, I'm
publishing these charts with Excel Services on our SharePoint site, so I
can't use a macro in them (won't publish). I'm also not sure it will work
even in Excel with the OLAP cube, but I haven't tried it yet (will do that
later today and report bacl). Any other thoughts?
 

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

pivot table rolling 12 month filter? 1
Rolling totals 1
Pivot Table Comparison 1
Rolling 12 month average 4
Custom date fields for pivot tables 4
Possible getpivotdata with offset? 1
Rolling 12 month total 7
grouping dates in a pivot table 1

Top