Spreadsheet: 883923d1732711644-sum-the-years-figures-region-wise-formula-support-jimsenthil-sample-339-spill-365-aligw
Sheet: Base

 |  |  |  |  | 22-23 |  |  |  |  |  |  |  |  |  |  |  | 23-24 |  |  |  |  |  |  |  |  |  |  |  | 24-25 |  |  |  |  |  |  |  |  |  |  |  | 25-26 AOP Plan
 |  | Zone | Segments | Region wise | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR
 |  | S1 | B2C-Retail | A | 111.43964 | 109.06028 | 116.654 | 136.08834 | 124.25829 | 127.15442 | 112.19622 | 120.52358 | 126.87242 | 133.44656 | 133.70981 | 152.50242 | 131.80364 | 120.20696 | 133.38815 | 147.91277 | 144.64898 | 143.95854 | 144.89015 | 127.92294 | 140.57176 | 160.12045 | 161.54516 | 165.98627 | 148.37982 | 142.54288 | 150.4577 | 177.3583 | 175.77926 | 168.71677 | 145.15133 | 169.865782635315 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | S1 | B2C-Retail | B | 9.33143 | 11.11125 | 9.45418 | 12.08468 | 11.84007 | 11.84994 | 9.48659 | 10.69856 | 11.13748 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | S1 | B2C-Retail | A | 37.02904 | 35.59558 | 38.79255 | 41.19722 | 44.32864 | 50.70365 | 43.70883 | 52.50128 | 57.35533 | 54.22209 | 53.21058 | 55.4172 | 51.21587 | 48.95734 | 48.71095 | 54.38847 | 52.8266 | 52.00317 | 55.36524 | 51.33153 | 50.96671 | 51.66797 | 55.93206 | 59.08413 | 49.81777 | 42.31735 | 49.49511 | 59.11814 | 53.62466 | 44.86747 | 46.0688 | 55.84408615028642 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | S1 | B2C-Retail | B | 76.06253 | 72.47718 | 74.70206 | 79.19117 | 79.60671 | 82.34272 | 71.71962 | 71.94786 | 87.46696 | 82.60604 | 81.98795 | 89.75689 | 71.64494 | 74.71881 | 77.58646 | 83.75728 | 82.47195 | 84.92778 | 82.90675 | 71.71644 | 76.0341 | 87.15664 | 87.21054 | 90.73115 | 80.76894 | 83.33808 | 82.7189 | 94.55909 | 89.33344 | 76.71741 | 70.25006 | 82.34114883568947 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | S1 | B2C-Retail | A | 120.54628 | 115.19227 | 113.33056 | 132.9271 | 128.49645 | 127.47795 | 116.20364 | 126.67526 | 135.36427 | 127.89379 | 129.4055 | 139.8174 | 127.7147 | 117.08932 | 116.06925 | 136.75064 | 125.50276 | 125.00236 | 129.16806 | 112.70532 | 121.17689 | 142.78779 | 150.84531 | 158.94637 | 140.15871 | 144.47395 | 155.28989 | 174.02031 | 173.29944 | 159.92934 | 147.23913 | 162.6120464137538 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | S2 | B2C-Retail | B | 0 | 0 | 0.0007 | 0.03405 | 0.00965 | 0.02303 | 0.01567 | 0 | 0.0143 | 0.02528 | 0.0007 | 0.00998 | 0 | 0 | 0.005 | 0.01068 | 0.06848 | 0.00697 | 0.02457 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0033 | 0.0306 | 0 | 0.0193 | 0 | 0.0009 | 0.01604135355698055 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | S2 | LAH | A | 134.95864 | 131.18179 | 124.65593 | 139.69989 | 129.01115 | 119.79226 | 119.56843 | 131.58105 | 138.96983 | 144.01386 | 137.0374 | 149.6599 | 131.94615 | 136.51091 | 133.54266 | 152.59787 | 154.7256 | 153.1402 | 152.82668 | 141.72249 | 156.08455 | 174.31408 | 171.33181 | 174.24308 | 154.23857 | 161.04531 | 175.09987 | 178.49758 | 177.24043 | 163.09168 | 167.42297 | 162.1053699909158 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | S2 | B2B | B | 1.31058 | 0.74257 | 0.85067 | 0.99693 | 0.78546 | 0.82337 | 0.77421 | 0.68218 | 0.90694 | 0.77124 | 0.89319 | 1.57897 | 1.79355 | 1.79199 | 1.74037 | 1.88408 | 1.8454 | 1.78469 | 1.85885 | 2.39541 | 1.791 | 2.33673 | 2.1838 | 2.03988 | 2.40651 | 1.70633 | 2.28211 | 1.66193 | 1.22051 | 1.17991 | 1.042 | 1.018069074863955 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | S3 | B2B | A | 57.66009 | 64.28316 | 57.79818 | 76.46014 | 80.0783 | 95.05372 | 78.25732 | 83.68761 | 86.71089 | 80.28058 | 77.60989 | 86.35531 | 67.97722 | 72.50981 | 73.72159 | 76.41203 | 82.07429 | 85.10968 | 76.82286 | 80.60724 | 77.48968 | 77.05107 | 79.85764 | 82.82592 | 84.06114 | 81.55078 | 85.38957 | 101.66127 | 92.33874 | 97.04317 | 90.7154 | 110.2465188770319 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | S3 | B2B | B | 19.60566 | 17.90448 | 19.39097 | 22.68343 | 19.38998 | 20.70721 | 18.86965 | 19.27028 | 18.51998 | 20.10691 | 18.7422 | 23.07203 | 22.00382 | 23.21157 | 23.22222 | 24.51112 | 24.46489 | 25.07415 | 26.61137 | 24.15404 | 21.72894 | 23.57636 | 30.62975 | 30.81325 | 27.96777 | 28.60901 | 26.68676 | 26.20504 | 26.39578 | 23.6603 | 27.94198 | 30.50209116102075 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0