Pivot Table help

[Looping through]

Is it possible to filter out information in a Pivot table range before you
actually look at pivot table compiled data?

I have a table that looks at a years worth of data (A4:W10000) as a whole
and filters out certain data based on criteria (Quote Number, Job Name,
etc...). I have two date columns (Date in and Date out) in the main source
data but I do not include a date field in the pivot table.

I would like to use the date out information to restrict the pivot table
data pulled in to only the information of the past 30 days. Is this possible?

thanks
Peter

 

[Hemant_india]

hi
why don't you insert date field in pivot
you can group the date field and can have desire reports

 

[Looping through]

The PT will not let me add a seventh data field to the table and the other
six fields are more important than the date out.

Any thoughts
Peter

 

[Hemant_india]

hi
i dident get u
i am using pivot table with around 18 fields