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

 |  |  |  |  | MTD Commerce Returned & Cancelled Orders |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STATUS | RETURNED
 | Sum of VALUE
 | WH | STATUS | RESPONSIBLE DEPT. | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WH | STATUS | RESPONSIBLE DEPT. | REASON CATEGORY | Sum of VALUE |  |  |  |  |  |  |  |  |  | DATE | Sum of VALUE | % of Grand Total
 | S901 | CANCELLED | SALES | 9963.91 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WH_01 | CANCELLED | PLANNING | Road Closure | 91.92 |  |  |  |  |  |  |  |  |  | 2024-01-03 00:00:00 | 799.86 | 0.008357902902622583
 |  |  | PLANNING | 248.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROCUREMENT | Rejected due to Short [NAME] | 615 |  |  |  |  |  |  |  |  |  | 2024-01-04 00:00:00 | 546 | 0.005705267152791652
 |  |  | PROCUREMENT | 615 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SALES | Double Order | 976.5600000000001 |  |  |  |  |  |  |  |  |  | 2024-01-07 00:00:00 | 3816 | 0.03987417482610429
 |  | RETURNED | SALES | 18974.55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LPO Expired | 826.91 |  |  |  |  |  |  |  |  |  | 2024-01-11 00:00:00 | 4208.74 | 0.04397799647736325
 |  |  | [NAME] | 58110.49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RETURNED | [NAME] | Delivery Time Out | 10785.23 |  |  |  |  |  |  |  |  |  | 2024-01-13 00:00:00 | 9124.05 | 0.0953390893139719
 |  |  | DATA ENTRY | 14800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SALES | Merchandise Not Available | 4909.580000000001 |  |  |  |  |  |  |  |  |  | 2024-01-14 00:00:00 | 11004.99 | 0.114993421179122
 |  |  | WAREHOUSE | 3816 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WAREHOUSE | [NAME] | 3816 |  |  |  |  |  |  |  |  |  | 2024-01-15 00:00:00 | 5688.950000000001 | 0.05944501752541038
 | S901 Total |  |  | 106528.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WH_02 | CANCELLED | PLANNING | LPO Expired | 156.15 |  |  |  |  |  |  |  |  |  | 2024-01-16 00:00:00 | 19574.51 | 0.2045381116025489
 | Grand Total |  |  | 106528.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SALES | Double Order | 3787.44 |  |  |  |  |  |  |  |  |  | 2024-01-17 00:00:00 | 31647.48 | 0.3306910771293604
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rejected by Customer | 4373 |  |  |  |  |  |  |  |  |  | 2024-01-20 00:00:00 | 9290.460000000001 | 0.09707794189070464
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RETURNED | DATA ENTRY | Wrong Customer Code | 14800 |  |  |  |  |  |  |  |  |  | Grand Total | 95701.04000000001 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [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