Naresh Yadav
Active Member
Respected All,
I have a data in column with heading name "cat", "Qty TGT" and "Value TGT" for FY 19-20
and I want the category wise YTD Sum of "Qty TGT" and Value "TGT"
kinldy find the attached file and expected result for your reference
regards
Naresh
I have a data in column with heading name "cat", "Qty TGT" and "Value TGT" for FY 19-20
and I want the category wise YTD Sum of "Qty TGT" and Value "TGT"
kinldy find the attached file and expected result for your reference
Expected Result | ||||||||||||||||||||||||
YTD Apr-19 to June-19 | ||||||||||||||||||||||||
Cat | YTD Qty TGT | YTD ValueTGT | ||||||||||||||||||||||
CJ | 20 | 123492 | ||||||||||||||||||||||
CP | 38 | 451491 | ||||||||||||||||||||||
CV | 9 | 40904 | ||||||||||||||||||||||
CZ | 0 | 0 | ||||||||||||||||||||||
DATA | ||||||||||||||||||||||||
TTL | 26 | 273107 | 21 | 204212 | 19 | 138568 | 22 | 129784 | 20 | 204172 | 18 | 201326 | 30 | 310349 | 39 | 385832 | 39 | 297444 | 51 | 325696 | 29 | 264740 | 28 | 300172 |
Apr-19 | Apr-19 | May-19 | May-19 | Jun-19 | Jun-19 | Jul-19 | Jul-19 | Aug-19 | Aug-19 | Sep-19 | Sep-19 | Oct-19 | Oct-19 | Nov-19 | Nov-19 | Dec-19 | Dec-19 | Jan-20 | Jan-20 | Feb-20 | Feb-20 | Mar-20 | Mar-20 | |
CAT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT | Qty TGT | VAL TGT |
CJ | 5 | 36765 | 7 | 47385 | 7 | 39342 | 11 | 50767 | 5 | 35769 | 4 | 26787 | 8 | 57650 | 15 | 103745 | 13 | 71464 | 13 | 61126 | 7 | 41378 | 5 | 34748 |
CP | 17 | 219770 | 11 | 144513 | 9 | 87208 | 8 | 69082 | 14 | 168403 | 14 | 174539 | 20 | 242799 | 22 | 270733 | 21 | 207572 | 30 | 242645 | 18 | 205306 | 21 | 257368 |
CV | 3 | 16572 | 3 | 12314 | 3 | 12017 | 3 | 9934 | 0 | 0 | 0 | 0 | 2 | 9900 | 3 | 11354 | 5 | 18408 | 8 | 21924 | 4 | 18056 | 2 | 8055 |
CZ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
regards
Naresh