Can a cell display the filter & criteria of currentPivotTable Filt
 

Hi. Excel 2007 PivotTable question.

I have setup a PivotTable for a report and will need to use a Date Filter to
select data for weekly, montly, quarterly reporting. I have collapsed the
Date field so it's not showing but only showing the Sales Reps and their
totals. But I can't figure out how to display on the report what date range
is currently selected or "filtered". The Table shows the icon that it has
been filtered but it doesn't show the values the filter is using so you can't
tell what the numbers represent. I hope you know what I mean.

Thanks.