-
1. Re: Selected measure comparison for two period in one table
Hi David Maning, so you want a bar chart view with one bar showing the measure value for one order date and the other bar for another order date ?
-
-
3. Re: Selected measure comparison for two period in one table
Hi Hari!
Thank you a lot for your response! That's to close to what I am looking for. However both those measures (for example Profit) should be compared by two parameters (year and month). For example, the first measure should show data for Y2017 M7 and second for Y2016 M3.
Thank you in advance!
Kind regards,
David
-
4. Re: Selected measure comparison for two period in one table
I guess what you really need will depend on the difference in the number of months between the 2 periods. So, in the solution I gave above, you can see that the difference is 12 months. You can create a numeric parameter with a value and make it available for the user to change as required, and use it in the above formula.
-
5. Re: Selected measure comparison for two period in one table
However I need to make changebale both those values on one table. Do you have any ideas how to make it?
Kind regards,
DImitriy
-
6. Re: Selected measure comparison for two period in one table
There is the following solution:
1) Create 4 parameters: Month 1, Month 2, Year 1, Year 2
2) Create two dates as calculation fields: MAKEDATE(INT([Year 1]),INT([Month 1]),01)
3) Create dates for columns:
DATE(IF [Year Month]=[Year Month 1]
THEN [Year Month]
END)
4) Put corresponding dates on columns and make them as dual axis.
Trust that this will help to more then just myself
Kind regards,
Dimitriy
