Report Filter in PivotTable

  • Thread starter Thread starter Hutch
  • Start date Start date
H

Hutch

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.
 
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
 
Back
Top