hi All,
I'm trying to create MOM% change displayed as line chart or Trend Line with Single select on year field.
the issue is when i select a single Year , for eg 2018 then MOM % calculated using table calculation disappears.
MOM% = (Jan 2018 - Jan 2017)/Jan 2017.
how do i show this in a line chart with single year select as show below. Attached is the work book.
Aug 15, 2018 5:26 AM
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
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