Pivot Table help

  • Thread starter Thread starter Looping through
  • Start date Start date
L

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
 
hi
why don't you insert date field in pivot
you can group the date field and can have desire reports
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Wanted to show 12 month Date in Pivot table 2
Change Pivot Table Filter Based on Cell Value 0
Pivot Table Question 2
Using VBA to create charts 1
Pivot table multiple filters 2
VBA Pivot Table Change Criteria - Help?! 1

Back
Top