locked
Is it posssible to have cascaded filters in reports in Microsoft Excel 2007? RRS feed

  • Question

  • Hi,

    I am working on dashboard project,and due to limitations of Performance point server we have decided to change the technology... we are planning to use excel for reporting..is it possible with excel to have linking between two filters?

    e.g.depending on the selection in first filter values in the next filter should change.

     

    regards,

    Abhay

    Wednesday, August 6, 2008 6:07 AM

Answers

  • Yes, you can always write macros to do this (should be posing on Excel forum). But before that why dont you consider SSRS report for this requirement? and its simple to import the SSRS report in PPS dashboard.

     

    Monday, August 11, 2008 9:55 PM