-
1. Re: Selected measure comparison for two period in one table
Teju pamarty Jan 11, 2018 11:51 AM (in response to David Maning)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 ?
-
2. Re: Selected measure comparison for two period in one table
Hari Ankem Jan 11, 2018 11:56 AM (in response to David Maning)-
Example (1).twbx 1.2 MB
-
-
3. Re: Selected measure comparison for two period in one table
David Maning Jan 11, 2018 12:28 PM (in response to Hari Ankem)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
Hari Ankem Jan 11, 2018 1:25 PM (in response to David Maning)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
David Maning Jan 11, 2018 10:39 PM (in response to Hari Ankem)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
David Maning Jan 12, 2018 2:45 AM (in response to David Maning)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