Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have fields like Sales_Org ,Cat, Product Group and Calendar_Month
Now in calendar month i have 12 months
Now i have a field called consumption
For example say
Month Cons
201701 10
201702 20
201703 30 and so on
Now what i need to get is if i select 201701 i need to get 10 then if i select 201702 i need to get 10+20 =20 and if i select 201703
i need to get 10+30 =60.
Can you please help me how can i do it. is it is possible to do in back end.
please let me know if you need anything more. Attached app for more ref
Thanks,
Bharat
You are looking to calculate rolling 12 months in the script? Is that what you are trying to do?
Month Cons
201701 10
201702 20
201703 30 and so on
Now what i need to get is if i select 201701 i need to get 10 then if i select 201702 i need to get 10+20 =20 and if i select 201703 i need to get 10+30 =60.
10+30 you are going to get or 10+20+30 ???