locked
counting months defined in filter RRS feed

  • Question

  • Hi. I have a problem I would like to see if anyone can help me solve. In my firm we have some KPI's that have a defined target pr. month which are inputtet by hand. The problem is that people like to be able to choose more then one month from the month filter and the target should be altered accordingly.

    Example:

    KPI  has a target of no more than 30 a month. When a user chooses to see the scorecard for 2 months, the target should be 60 and so on.

    I have experimented a bit with the count function to try to count the months using allmembers (count([Date].[months].allmembers)) and multiply that with the constant, but it does not seem to change with the filter like I would expect.

    Does anyone have a idea on how to accomplish this?

    Ásgeir Gunnarsson

     
    Friday, December 5, 2008 1:49 PM

Answers

  • Try using this instead:

        count(existing([Date].[Month].members))


    This should provide the count of the number of months being referenced.

    • Proposed as answer by Dan English Tuesday, December 30, 2008 11:04 AM
    • Marked as answer by AseemN Tuesday, January 13, 2009 6:51 PM
    Monday, December 15, 2008 12:32 AM