Skip to Content
avatar image
Former Member

Dynamic filter on measure based on prompt

Dear Community,

I´m trying to filter a measure based on the prompt. The user is able to select an intervall for the time period (e.g. January 2015 - September 2015) in prompt. In the Report the user shall see the months 01-09 for one measure but also see the month 09 for the second measure.

But the user also should be able to select another Intervall of month (e.g. 01.2015-08.2015) then the second measure should be for 08.2015.

Is there a specific function which I can use?

Thanks and kind regards,

Ann-Christin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 21, 2015 at 09:27 AM

    Hi,

    If you have Month object in the report which populating the all months based on the user response then use Last function to capture the value like 08 or 09.

    V Month=Last([Month])

    After that for measure create a variable like.

    V Last Month value=[Measure] where ([Month]=Last([Month]))

    Amit

    Add comment
    10|10000 characters needed characters exceeded