This content has been marked as final.
Show 2 replies
-
1. Re: MOM% change showed as Line chart with single year select.
Zhouyi ZhangAug 15, 2018 5:26 AM (in response to Udayambika Nair)
Hi, Udayambika
Please find my solution attached.
Below is the testing result. you can make sheet 1 as line chart by dragging the measure to the row
Hope this helps
ZZ
-
Book2 (8)_v10.2.twbx 58.6 KB
-
-
2. Re: MOM% change showed as Line chart with single year select.
Naveen B Aug 15, 2018 5:37 AM (in response to Udayambika Nair)Hi Uday,
Check the attached file
replace the year with lookup(attr(year field),0) so when you select 2018 still 2017 will be in the picture and you get the correct value
Calc field to use:
Hope this helps kindly mark this answer as complete or helpful so that it will help others
BR,
NB
-
Book2_v10.3.twbx 64.6 KB
-