Find the attachment for the excel that i've created for a mock of what is the input and what i am trying to achieve for the output. I have units listed for every month. I would need to create a field called Range which will have column values like 3M forward(which should dynamic and right now this values will consider the next 3 months including present month), 6M forward and on. The calculation for the units will sum(units) but by default this will show the sum(April+may+june months units) which will be a 3M forward. but when i change my value to 6 month forward then the calculation will adjust to april thru sep in this case and this should be dynamic. I couldn't figure out a way to do this. Hope i can find some help on this here?
I think this is little bit similar to what i was looking. But the months should be dynamic like 3M should be in this case starting from present month +2 (April+may+june) same thing with 6M and 9M. Because when we roll into 2015 then you will have 3M( jan thru March), 6M(Jan thru June),9M and 12M but again this future look up.