Spreadsheet: 682480d1592133152-conditional-sum-with-multiple-criteria-new-microsoft-excel-worksheet-2-
Sheet: Pivot Table

Row Labels | QTY | TOTAL QTY | Live Qty | Hold Qty | [NAME]
Dunnes | 707494 | 154 | 807572 | 0 | 807572
Baby Boys (D) | 471425 | 100 | 501485 | 0 | 501485
AW20 PH-01 | 298958 | 66 | 321015 | 0 | 321015
AW20 PH-02 | 172467 | 34 | 180470 | 0 | 180470
[NAME] (D) | 236069 | 54 | 306087 | 0 | 306087
AW20 PH-01 | 236069 | 54 | 306087 | 0 | 306087
George | 7945393 | 1428 | 10283876 | 0 | 10283876
Boys Essential | 190969 | 66 | 546296 | 0 | 546296
AW20 PH-05 | 22459 | 6 | 109156 | 0 | 109156
AW20 PH-06 | 59320 | 24 | 59688 | 0 | 59688
AW20-PH-07 | 21980 | 3 | 16008 | 0 | 16008
SS20 PH-01 | 46306 | 21 | 245092 | 0 | 245092
SS20 PH-03 | 40904 | 12 | 116352 | 0 | 116352
BT Boys | 946223 | 239 | 1250600 | 0 | 1250600
AW20 PH-05 | 196829 | 56 | 226373 | 0 | 226373
AW20 PH-07 | 247010 | 55 | 266300 | 0 | 266300
AW20 PH-08 | 180882 | 57 | 247822 | 0 | 247822
SS20-PH-03 | 32172 | 12 | 32172 | 0 | 32172
SS20-PH-04 | 190477 | 47 | 281327 | 0 | 281327
SS21 PH-01 | 98853 | 12 | 196606 | 0 | 196606
BT Girls | 328777 | 136 | 808554 | 0 | 808554
AW20 PH-05 | 46247 | 24 | 109445 | 0 | 109445
AW20 PH-07 | 47492 | 19 | 123846 | 0 | 123846
AW20 PH-08 | 36865 | 18 | 84524 | 0 | 84524
SS20 PH-03 | 32080 | 9 | 79244 | 0 | 79244
SS20 PH-04 | 161572 | 63 | 405381 | 0 | 405381
SS20-PH 01 & 02 | 4521 | 3 | 6114 | 0 | 6114
Ladies | 2036560 | 353 | 2470848 | 0 | 2470848
AW20 PH-06 | 784168 | 77 | 693988 | 0 | 693988
AW20 PH-08 | 50272 | 12 | 68284 | 0 | 68284
SS20 PH-01 | 15000 | 1 | 15000 | 0 | 15000
SS20 PH-02 | 70476 | 20 | 70476 | 0 | 70476
SS20 PH-03 | 276332 | 80 | 414140 | 0 | 414140
SS20 PH-04 | 374424 | 82 | 509340 | 0 | 509340
SS20 PH-05 | 465888 | 81 | 699620 | 0 | 699620
Men's | 2571929 | 161 | 2327546 | 0 | 2327546
AW20 PH-05 | 25000 |  | 0 | 0 | 0
SS20 PH-01 | 445960 | 36 | 485948 | 0 | 485948
SS20 PH-03 & 04 | 1851709 | 125 | 1841598 | 0 | 1841598
SS20 PH-04 | 249260 |  | 0 | 0 | 0
OL Girls | 1059214 | 304 | 1376552 | 0 | 1376552
AW20 PH-05 | 438531 | 153 | 566631 | 0 | 566631
AW20 PH-07 | 151488 | 28 | 137692 | 0 | 137692
AW20 PH-08 | 60458 | 9 | 60458 | 0 | 60458
SS20 PH-03 | 37670 | 6 | 39190 | 0 | 39190
SS20 PH-04 | 327377 | 92 | 515731 | 0 | 515731
SS21 PH-01 | 43690 | 16 | 56850 | 0 | 56850
[NAME] | 54288 | 20 | 73672 | 0 | 73672
SS20 PH-02/04 | 54288 | 20 | 73672 | 0 | 73672
School Wear | 757433 | 149 | 1429808 | 0 | 1429808
AW20 PH-05 | 637359 | 119 | 1245690 | 0 | 1245690
SS20 PH-01 | 120074 | 30 | 184118 | 0 | 184118
Morrisons | 1352273 | 422 | 1698531 | 0 | 1698531
Baby Wear(M) | 7138 | 2 | 7138 | 0 | 7138
AW20 PH-01 | 7138 | 2 | 7138 | 0 | 7138
Boys Essential(M) | 245660 | 127 | 547414 | 0 | 547414
SS20 PH-01 | 245660 | 127 | 547414 | 0 | 547414
Ladies'(M) | 797636 | 198 | 815852 | 0 | 815852
AW20 PH- 1&2 | 730232 | 176 | 738416 | 0 | 738416
SS20 PH-01 | 67404 | 22 | 77436 | 0 | 77436
Older Girl's(M) | 117128 | 37 | 143416 | 0 | 143416
SS20- AW20 | 16967 | 6 | 16967 | 0 | 16967
SS20 PH-01 | 100161 | 31 | 126449 | 0 | 126449
[NAME]) | 184711 | 58 | 184711 | 0 | 184711
SS20 PH-01 | 184711 | 58 | 184711 | 0 | 184711
Grand Total | 10005160 | 2004 | 12789979 | 0 | 12789979