rolling 12 month date filter for pivot table?

  • Thread starter Thread starter Randy Suggs
  • Start date Start date
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.
 
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?
 
Back
Top