Hi Expert,
I have small requirement that In my data file I have fields like below
Month,sales
Jan,10
Feb,20
Mar,30
Apr,40
May,50
Jun,60
July,70
***********************
Requirement is I have keep one input box to enter dynamic values.
Ex: current month is Jan so if user enter some value like 12 then 10(jan) value has to be replace with 12 and in next month value should be change with result like below
-->Input box [In the input box user enter like 12]
Month,sales Result
Jan,10 12
Feb,20 18 [ it will get 12(input box vlaue)-10(jan value)] =2----> 20-2 == 18
Mar,30
Apr,40
******************
up to this I achieved
but if user enter like below how carry forward into next months like mar,apr,may...
-->input box [if user enter 34]
Month,sales Result
Jan,10 34 -->it is replacing with input box value
feb,20 0 --- (34(inputbox value)-10(jan value)=24(remain value)) -->20(feb value)-24 =0 this month result and 4 is remain value
mar,30 26 -- remaing value (4)-30(Marvalue= 26)
apr,40
Kindly give some suggestion.
Thanks in advance...........
