Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table Customize functions in the Data Field | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table | Excel Worksheet Functions | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |