Pivot Table - Filtering Page Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple jobs sold list with dates and salesman. I would like to put
the date on the page field and then filter by periods like month or quarters.
But I dont see anyway for appling an advanced filter for a less than and
greater than date. selecting individual date entries would be tedious.
Thanks for any suggestions.
 
If I understand your question correctly, you could try putting date data in
the Row Field.
Then, right-click on a date and choose Group and Show Detail. Click Group...
Then, choose the Time Periods you want to group the dates by.
Click Okay.
You will know have new Row Fields. Drag Months or Quarters to the page
Field, and drag the ones you don't want off the table.

tj
 
You must log in or register to reply here.

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

date filter in a pivot table 1
Grouping Dates in Excel 2007 Pivot Tables 1
Pivot Table: use a field in two different places 3
pivot table rolling 12 month filter? 1
filtering dates in a Pivot Table Report Filter 3
XL2007: Pivot table date filter 1
pivot table value filter 1
Pivot Table 1

Back
Top