9 Replies Latest reply: Apr 23, 2014 12:42 PM by Dinesh Kumar RSS

    Any insight on how this could be done?

      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?

       

      Thanks in advance.