Hello,
This is a sample from my data table:
Date | Profit | Loss |
1/1/2011 | 100000 | 50000 |
2/1/2011 | ||
3/1/2011 | ||
4/1/2011 | ||
5/1/2011 | ||
6/1/2011 | ||
7/1/2011 | ||
8/1/2011 | ||
9/1/2011 | ||
10/1/2011 | ||
11/1/2011 | ||
12/1/2011 | ||
1/1/2012 | 90000 | 47000 |
2/1/2012 | ||
3/1/2012 | ||
4/1/2012 | ||
5/1/2012 | ||
6/1/2012 | ||
7/1/2012 | ||
8/1/2012 | ||
9/1/2012 | ||
10/1/2012 | ||
11/1/2012 | ||
12/1/2012 | ||
1/1/2013 | 80000 | 41000 |
2/1/2013 | ||
3/1/2013 | ||
4/1/2013 | ||
5/1/2013 | ||
6/1/2013 | ||
7/1/2013 | ||
8/1/2013 | ||
9/1/2013 | ||
10/1/2013 | ||
11/1/2013 | ||
12/1/2013 | ||
1/1/2014 | 70000 | 36000 |
What I am trying to do is fill the empty values of the remaining dates.
The value in the first month for each year is actually the total for the whole year. So, "100,000" profit is profit for the whole year. I am splitting this "100,000" into 12 months to get a prediction of profit by month. However I need assistance in filling all the remaining empty rows in that year so that they decrease over time and do not overlap with the following years first month.
By that I mean that the December month of the prior year should be greater than the first month of the next year. This is to prevent staggering graphics
Thank you.
@devalex I don't exactly follow but does this help?
So I'm trying to have the values decrease progressively by month. In the example you showed they are decreasing but only by year. I need them to decrease incrementally each month. No month should have the same value.