Spreadsheet: 857686d1706633013-need-help-with-kpi-reports-commerce-return-and-cancelled-orders-17012024-i_scarface-
Sheet: Summary

 |  |  |  |  | MTD Commerce Returned & Cancelled Orders
 | Sum of VALUE
 | WH | STATUS | RESPONSIBLE DEPT. | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WH | STATUS | RESPONSIBLE DEPT. | REASON CATEGORY | Sum of VALUE
 | S901 | CANCELLED | SALES | 9963.91 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WH_01 | CANCELLED | PLANNING | Road Closure | 91.92
 |  |  | PLANNING | 248.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROCUREMENT | Rejected due to Short [NAME] | 615
 |  |  | PROCUREMENT | 615 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SALES | Double Order | 976.5600000000001
 |  | RETURNED | SALES | 18974.55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LPO Expired | 826.91
 |  |  | [NAME] | 58110.49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RETURNED | [NAME] | Delivery Time Out | 10785.23
 |  |  | DATA ENTRY | 14800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SALES | Merchandise Not Available | 4909.580000000001
 |  |  | WAREHOUSE | 3816 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WAREHOUSE | [NAME] | 3816
 | S901 Total |  |  | 106528.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WH_02 | CANCELLED | PLANNING | LPO Expired | 156.15
 | Grand Total |  |  | 106528.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SALES | Double Order | 3787.44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rejected by Customer | 4373
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RETURNED | DATA ENTRY | Wrong Customer Code | 14800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Delivery Time Out | 47325.26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SALES | Delivery Date Re-scheduled After Delivery | 4774.51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Double Order | 941.76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Merchandise Not Available | 8348.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  |  | 106528.02
 |  |  |  |  |  | Sum of VALUE
 |  |  |  |  |  | STATUS | RESPONSIBLE DEPT. | DRIVER NAME | Total
 |  |  |  |  |  | CANCELLED | SALES | [NAME] 1 | 1143.44
 |  |  |  |  |  |  |  | [NAME] 2 | 660.03
 |  |  |  |  |  |  |  | [NAME] 3 | 2145
 |  |  |  |  |  |  |  | DRIVER 5 | 1114
 |  |  |  |  |  |  |  | [NAME] 6 | 557
 |  |  |  |  |  |  |  | DRIVER 7 | 557
 |  |  |  |  |  |  |  | DRIVER 10 | 1314.48
 |  |  |  |  |  |  |  | DRIVER 11 | 958.08
 |  |  |  |  |  |  |  | DRIVER 12 | 1514.88
 |  |  |  |  |  |  | SALES Total |  | 9963.91
 |  |  |  |  |  |  | PLANNING | [NAME] 2 | 91.92
 |  |  |  |  |  |  |  | [NAME] 3 | 156.15
 |  |  |  |  |  |  | PLANNING Total |  | 248.07
 |  |  |  |  |  |  | PROCUREMENT | [NAME] 1 | 570
 |  |  |  |  |  |  |  | [NAME] 2 | 45
 |  |  |  |  |  |  | PROCUREMENT Total |  | 615
 |  |  |  |  |  | RETURNED | SALES | [NAME] 1 | 210.24
 |  |  |  |  |  |  |  | [NAME] 2 | 4699.34
 |  |  |  |  |  |  |  | [NAME] 3 | 4774.51
 |  |  |  |  |  |  |  | DRIVER 13 | 941.76
 |  |  |  |  |  |  |  | [NAME] 14 | 1839.12
 |  |  |  |  |  |  |  | DRIVER 15 | 6509.58
 |  |  |  |  |  |  | SALES Total |  | 18974.55
 |  |  |  |  |  |  | [NAME] | [NAME] 1 | 1135.62
 |  |  |  |  |  |  |  | [NAME] 2 | 8633.45
 |  |  |  |  |  |  |  | [NAME] 3 | 17928.62
 |  |  |  |  |  |  |  | [NAME] 4 | 2640.3
 |  |  |  |  |  |  |  | [NAME] 8 | 4410
 |  |  |  |  |  |  |  | DRIVER 9 | 23362.5
 |  |  |  |  |  |  | LOGISTICS Total |  | 58110.49
 |  |  |  |  |  |  | DATA ENTRY | [NAME] 3 | 14800
 |  |  |  |  |  |  | DATA ENTRY Total |  | 14800
 |  |  |  |  |  |  | WAREHOUSE | [NAME] 1 | 3816
 |  |  |  |  |  |  | WAREHOUSE Total |  | 3816
 |  |  |  |  |  | Grand Total |  |  | 106528.02