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?

"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
Last x months.
Two ways:
http://c0444202.cdn.cloudfiles.racks.../01_05_10.xlsm
.