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. |
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 |
All times are GMT +1. The time now is 10:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com