View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SHW SHW is offline
external usenet poster
 
Posts: 2
Default Are Date filters available for items in the Filter area of pivot t

When a pivot table is created using SSAS source and Date dimension is set up
correctly, Date filters are available when Date attributes are added to the
rows or columns area of the report. For example, data can be filtered to show
only data for This Year, Last Year, etc.
However, if same Date attributes are added to the filter area, the only
filtering option that is available is manual filtering by choosing from a
list.
Is it possible to use Date filters like This Year, YTD, without adding the
Date attributes to the rows/columns area?

Thanks,