Hi All ,
I need some help to implement this logic . I am sharing the data for only one code But in actual huge number of code is available in my data . I am attaching logic screen shot with aspect result. data in the below table
B | key | planned | Actual | |
420000615 | Jan 2019 | 0 | 24558 | |
420000615 | Feb 2019 | 0 | 20631 | |
420000615 | Mar 2019 | 15000 | 27517 | |
420000615 | Apr 2019 | 163000 | 78576 | |
420000615 | May 2019 | 74000 | 72701 | |
420000615 | Jun 2019 | 28000 | | |
420000615 | Jul 2019 | 50000 | 0 | |
420000615 | Aug 2019 | 97000 | 0 | |
420000615 | Sep 2019 | 0 | 0 | |