LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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,

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to filter field button items in pivot tables ajholloway Charts and Charting in Excel 4 October 11th 08 02:27 PM
Pivot Tables - Date Filters Craig Excel Discussion (Misc queries) 0 October 7th 08 07:05 PM
Pivot Table filters, especially DATE filters chris Excel Worksheet Functions 0 August 27th 08 04:33 AM
Pivot Table DATA area drop down menu items disapper after switchof Kith Excel Discussion (Misc queries) 1 April 30th 07 03:35 AM
How do I find all items with the same value without using filters Fiona-NZ Excel Worksheet Functions 4 July 7th 06 02:06 AM


All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"