Pivot Table Parameters in Excel 2007???

[jeffm777]

I've got a pivot table that I want to assign parameters to. I can accomplish this if I do a normal data query and then base my pivot table off of it but I was wondering if this can be done if the pivot table is created directly from the external ODBC data source.

I need two parameters - a start date and an end date.

Thanks in advance for any help or advice.

 

[SkipVought]

Hi,

Sure, in the date field in your PT, you can specify all sorts of criteria. Much more flexible than previous versions!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}