Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to filter field button items in pivot tables | Charts and Charting in Excel | |||
Pivot Tables - Date Filters | Excel Discussion (Misc queries) | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
Pivot Table DATA area drop down menu items disapper after switchof | Excel Discussion (Misc queries) | |||
How do I find all items with the same value without using filters | Excel Worksheet Functions |