Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have one requirement on Expression enable condition.
We have 3 years i.e 2016 , 2015 and 2014 data with sales value. We have to design trend chart for above 3 years.
Month will be dimension and Sales value is our measure field And Year as a selection filter..
Requirement is when we select 2016 and 2015 both year at a time then Two trend line should be seen in line chart. And when I select 2014 and 2016 then related trend line should be shown in same line chart.
After doing 2014 and 2015 year selection then related trend line should be shown in same Line Chart..
Have attached the data for your reference. Kindly help me over this.
Thanks
Gourav
please close your open threads that received correct answers.
thanks
regards
Marco
Dear Marco
I have closed my open threads. Please help me on above requirement...
Thanks
Gourav
Hi Gourav,
This time you have to create three exp in line chart you will easily reach your requirement.
Dimention is month and expretion is
1).sum(sales).
2).sum(sales).
3).sum(sales).
need to write condition if(Year=2016,1,0) for all Exp for shwoing.
Regards
Sathish
Check attached, if this is what you are looking for?