Need to show amount with increment of one month.
I need help to show the following info as shown below. I am using 0CALMONTH as input and using variable to take range like 06.2009 - 07.2010.
Now I have two columns to show Key figure amount value. I am using 0CALMONTH on 1st column to restirct with imput value.
However, in 2nd column I need to show the same amount but increment with one month.
Date Column A Column B
06.2009 $100 $200
07.2009 $200 $300
08.2009 $300 $400
09.2009 $400 etc..
Please let me know how can I show the $200 onward amount in Column B.
Thanks for the help.