convert cumulative sales into monthly sales and plot in bar chart
Thanks for the solution,
I am getting an absurd error when using this logic. All my cumulative sales are converted into monthly sales except for year 2014 7th month. It is showing monthly values same as cumulative values. however when I checked it into excel its working fine.
Re: convert cumulative sales into monthly sales and plot in bar chart
The data for this year month has been calculated by the formula. This is exactly the problem which we are facing. we have cumulative data and we are calculating monthly value out of it. but for this particular month it is showing same value. i have no clue Y?