I have combo chart in my application.
In this, the bars are displaying for 12 months. If the current month is Dec, then the bars are displaying from Jan 2016 to Dec 2016
If user selected the month Jul in the year 2016, then it is showing Aug of the 2015 to Jul in 2016.
now, my requirement is to display the line showing the percentage change from month month in the bars.
I have selected Jul 2016 as my current month in the attached file. so , it is displaying from 2015 aug to 2016 Jul
How to calculate the % change without changing the sort order.
Here the Express is Sum(Paidvalue)
All the above are working fine only when the month numbers are in sequence in the single year. If the months are from different years, i am not getting the correct %change values.