on 10-21-2015 7:16 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit Kumar,
Thank you for your fast reply.
If I create a variable like V Last Month Value = [Measure] where ([Month]=Last[Month]), I´ll get back the sum for the whole Intervall (in this case from 01.2015-09.2015). But I just want to see the last month (or better to say the Maximum of month selected).
Kind regards,
Ann-Christin
Hi,
great, the first variable is already working!
But I have a further requirement to the issue of variable. At the Moment the variable gives me the sum for the last month back. But I want to see the result for every Distribution channel too.
I give you an example:
The left table shows you the issue of the variable and the right one shows you the result how it should be.
Kind regards,
Ann-Christin
Hi,
this is not working. The result of this variable is the sum of highest Distribution channel. In my example the sum for Distribution Channel 99.
I have also tried a variable like the following, but then i get back the sum for every distribution channel for the whole interval (01.2015-09.2015)
V= ([Sales Revenue] In [Distribution Channel]) Where ([Month]=Last([Month]))
Ann-Christin
Hey Ann,
Create the below 2 variables as measures.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.