Pivot table and filters
 

Hi.

Am using Excel 2007 and have a quick question. Am trying to make a
dynamic title for a chart I have and am using a page level filter for
the fiscal week (you can select multiples). See below as an example:

Fiscal Week
-W1
-W2
-W3
- W4

Now lets say I choose to filter the data in my pivot table to only
show weeks 1-3....excel puts the text (Multiple Items) as the value of
the filter. What I want to do is look at that filter and determine
what the max week selected is and display that value in my header:

So instead of something like "Revenue for (Multiple Items)" it should
say "Revenue up to W3"

M