Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
replied

Hey Ann,

Create the below 2 variables as measures.

  • v_Max Month =If([Month]=Max([Month]) In Report) Then 1 Else 0

  • v_Amt for Max Month =[Amount] Where (([v_Max Month]=1) In ([Month]))

Voila


You'll see that for all the Months & Distribution Channels, the measure v_Amt for Max Month shows the Amount from Max Month for that Distribution Channel.

Let me know if that helps.


Thanks,

Mahboob Mohammed

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question