04-17-2018 12:08 PM
I am doing a report where I give the option to the user to choose either displaying the current month , if he chooses "Mês" from the button bar, or to display the values over the previous months including the current month, if he chooses "YTD".
I tried to use a Derived Item, but it is not helpful as it gives a single value, also I tried calculated items with parameters, and I got lost.
Any one has a suggestion ?
04-17-2018 01:24 PM
Have you thought about using the slider control object for selecting YTD?
I would suggest you take a look at this topic, there is a lot of useful info that may help you:
04-18-2018 02:44 AM
DO you have two different meassures one for current and one for YTD?
That should be the first step, add them in a table and check that they work
If so I think you could do the following:
- Create a new parameter and assign it to the button bar.
- Create a new calculated meassure that select either current or YTD depending on the parameter. (IF [parm] = 'Current' then current_var else YTD_var)
- Use that new meassure in your report.
Might help or am I out in the blue
04-30-2018 12:35 PM
Thanks for the help.
The problem is that I need to do more calculations, for example , we are in May 2018, but if someone choose March 2018 it should give the sum from January to March, and in this case the YTD_VAR doesn't give the expected results.