Date Range Filter for Excel Services RRS feed

  • Question



    I want to use Excel Services to publish summary KPI values for a customer project. However, the customer needs to be able to change the dates for which the KPIs are calculated, by entering enter a DATE RANGE .


    I CAN connect the filter to multiple web part controls. The problem is that the pivot table filters are exact matches. i.e. if I use a date filter, the pivot table only selects records for that exact day. What I really want is two filters in SharePoint (a FROM date and a TO date) which can then be applied to select records that are between the two dates.


    Tuesday, January 8, 2008 2:56 PM