Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
Sum of SALESColumn Labels Row LabelsClassic CarsMotorcyclesPlanesShipsTrainsTrucks and BusesVintage CarsGrand TotalGrand Total3919615.661166388.34975003.57714437.13226243.471127789.841903150.8410032628.85
| Cancelled | 59242.81 | 35432.71 | 56665.65 | 5082.42 | 38063.89 | 194487.48 | |||||||
| Disputed | 26012.87 | 31821.9 | 3843.84 | 3070.4 | 7463.85 | 72212.86 | |||||||
| In Process | 57760.66 | 43026.41 | 43942.89 | 144729.96 | |||||||||
| On Hold | 49039.65 | 4992.61 | 34727.53 | 23664.61 | 5808.48 | 20193.29 | 40553.02 | 178979.19 | |||||
| Resolved | 25799.34 | 34532.92 | 39863.71 | 20472.75 | 30049.56 | 150718.28 | |||||||
| Shipped | 3701760.33 | 1129573.83 | 866466.57 | 591172.76 | 215352.57 | 1044097.39 | 1743077.63 | 9291501.08 | |||||