Report Filter in PivotTable

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

 

[Debra Dalgleish]

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