Are Date filters available for items in the Filter area of pivot t


S

SHW

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,
 
Ad

Advertisements

S

Shane Devenshire

Hi,

I can't experiment with a SSAS data source but based on my experiments with
..Cub files, and the basic idea behind OLAP processing, I would expect that
you can not use the special filters on dates when a date attribute has been
added because the processing has already been done on the server.

Cheers,
Shane Devenshire
 
Ad

Advertisements

S

SHW

Thanks for your response. The Date filters are available for date attributes
when they are used in the rows or columns areas of a report. See this link
about filtering in pivot tables:

http://office.microsoft.com/en-us/excel/HA101677951033.aspx

So far the only workaround I have is to add the date attribute to the
columns area (before values) and hide it. Then I can set the filter from
field list.

SHW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top