View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hutch Hutch is offline
external usenet poster
 
Posts: 16
Default 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.