Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
R. G. Ingersoll
 
Posts: n/a
Default Pivot Table - Filtering Page Field

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.
--
Ingersoll
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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

"R. G. Ingersoll" wrote:

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.
--
Ingersoll

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 05:32 PM
Pivot Table Customize functions in the Data Field PSKelligan Excel Discussion (Misc queries) 2 January 4th 05 06:51 PM
Calculated Field in Pivot Table Edgar Thoemmes Excel Worksheet Functions 0 December 23rd 04 11:59 AM
Setting default pivot table field setting to "sum" Mr. Moose Excel Discussion (Misc queries) 2 December 21st 04 04:43 PM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 05:39 AM


All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"