Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Report Filter in PivotTable
I am putting together a pivottable and would like to be able to filture the
report for all records that are less than a certain date. However, it does not appear that the "Date Filter" option is available for fields you put in the Report Filter section. Am I missing something? I know I could move the date field in question down to the Row Labels section to use the Date Filter, but my problem is that I do not want to it group on that field since almost each record has a different date. Thanks, for any help that you can give. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Report Filter in PivotTable
You're correct. Unfortunately the date filter isn't available in the
Report Filters. You can manually uncheck the dates in the Report Filter dropdown list. Or, add a column to the source data, to compare the record's date with the target date. For example: =A2<Report!B5 Add that field to the Report Filters, and filter for TRUE Hutch wrote: I am putting together a pivottable and would like to be able to filture the report for all records that are less than a certain date. However, it does not appear that the "Date Filter" option is available for fields you put in the Report Filter section. Am I missing something? I know I could move the date field in question down to the Row Labels section to use the Date Filter, but my problem is that I do not want to it group on that field since almost each record has a different date. Thanks, for any help that you can give. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to refresh a Scenario PivotTable Report? | Excel Discussion (Misc queries) | |||
Hide zero values in a PivotTable report | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable Report Filter area not working | Excel Discussion (Misc queries) | |||
Multiple page report in a pivottable | Excel Discussion (Misc queries) | |||
How do I run a pivottable report w/ multiple worksheets? | Excel Discussion (Misc queries) |