Spreadsheet: 147420d1332786614-excel-2007-pivot-table-query-and-total-dashboardexample
Sheet: Repair Cost Data

Month | (All)
Year | 2012
 | Week Number
Department Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Grand Total
100000 | 2183.5538 | 838.4301000000002 | 1922.0601 | 1589.2204 | 1523.5248 | 1819.3579 | 1744.5296 | 3331.3487 | 2064.7642 | 2481.8597 | 2762.7076 | 186.405 | 22447.7619
100001 | 379.6387 | 3469.6515 | 5012.162200000001 | 2164.7398 | 1801.4892 | 432.6495 |  | 1045.8137 | 396.877 | 504.6017 | 1199.6106 |  | 16407.2339
100005 |  |  |  |  |  |  |  |  |  | 370 |  |  | 370
100010 | 4975.1297 | 1699.8804 | 116.0551999999998 | 636.2221 | 2236.4598 | 458.244 | 1024.5937 | 2168.8408 | 3423.0923 | 1110 | 2957.9832 | 983.2863 | 21789.7875
100011 | 6928.666700000003 | 4449.8874 | 10170.83719999999 | 7274.4296 | 7862.3749 | 8101.9082 | 8296.071700000002 | 12406.25329999999 | 6989.235500000002 | 10472.18690000001 | 8514.216800000002 | 2921.4645 | 94387.53269999998
100012 | 4875.9806 | 1775.7813 | 774.1020000000001 | 2344.1773 | 4432.5494 | 626.5934 | 1245.9265 | 3491.8548 | 548.3492 | 3111.4382 | 5079.6224 | 1185.2528 | 29491.6279
100013 | 4832.9126 | 4685.790099999999 | 8180.727100000001 | 5769.713799999999 | 7299.610200000001 | 5584.0728 | 13690.55890000001 | 9855.4211 | 5793.296200000001 | 8058.2241 | 4639.0861 | 1184.454 | 79573.86700000001
100014 | 22650.67350000003 | 25007.4592 | 28271.4495 | 27474.24689999997 | 22596.15909999999 | 21377.42719999999 | 22012.42199999999 | 21839.37590000001 | 15534.09470000001 | 23522.36399999999 | 26319.0627 | 9563.816700000005 | 266168.5514000001
100015 | 1042.0584 | 1078.4341 | 1637.7771 | 1500.8798 | 1283.6855 | 1088.4856 | 2531.1008 | 1898.0556 | 664.1220000000001 | 973.8215999999998 | 1035.0612 | 617.3039000000001 | 15350.7856
100016 | 6475.4543 | 6180.439499999999 | 8235.8847 | 8171.133100000001 | 7283.4053 | 6516.6939 | 3865.1302 | 8584.823900000001 | 4870.625900000001 | 8928.918200000002 | 7906.7238 | 3018.6103 | 80037.8431
100017 | 1393.8777 | 2800.2731 | 791.289 | 2392.0962 | 5646.1957 | 1622.5331 | 1139.7758 | 3708.0457 | 2633.5033 | 2958.9049 | 2793.1605 | 541.2247 | 28420.8797
100018 | 207.3244 | 20.5078 | 438.6201 | 223.1882 | 132.3816 | 466.1809000000001 | 482.9594 | 414.855 | 197.911 | 1685.9408 | 21.675 | 32.5125 | 4324.0567
100020 |  |  |  | 20.8224 | 70.2615 | 63.462 | 91.1133 |  |  |  |  |  | 245.6592
100021 | 5419.411499999999 | 2627.5931 | 1253.9323 | 5477.3181 | 4298.9958 | 3136.112 | 756.8451 | 71.2189 | 1018.5757 | 5052.5083 | 4338.913599999999 | 677.4072 | 34128.8316
100022 |  | 74.6136 |  | 38.1744 |  | 300.0846 |  | 50.286 | 12.95 |  | 563.325 |  | 1039.4336
100023 | 2985.783 | 2630.8241 | 813.753 | 42.43 | 378.7634 | 1017.2013 | 4799.478899999999 | 1107.4598 | 956.8957 | 3701.7515 | 1326.3497 | 1752.9749 | 21513.6653
100073 | 5174.989500000001 | 5880.801699999998 | 2556.64 | 6919.029999999999 | 6381.745199999999 | 5177.969999999999 | 6894.3557 | 8351.537300000002 | 5611.615 | 9994.976700000001 | 9479.368999999999 | 1647.625 | 74070.6551
100076 | 7480.649899999999 | 8993.4964 | 12957.265 | 5089.301 | 6785.573000000001 | 9256.9076 | 26005.08770000001 | 23604.7466 | 8448.750199999999 | 8741.793400000002 | 6814.0569 | 1901.8135 | 126079.4412
100077 | 5728.9548 | 8563.485199999997 | 13614.2843 | 14935.06259999999 | 16205.61150000001 | 27533.73329999997 | 18291.84259999998 | 9653.671000000004 | 9136.561700000006 | 12045.73400000001 | 9320.569999999994 | 2692.031 | 147721.542
100078 | 362.64 | 113.325 |  | 336.4699 | 594.8686 | 8.486 | 84.86 | 417.3296 |  |  | 406.623 |  | 2324.6021
100079 | 2912.2761 | 2777.2553 | 1146.0343 | 1129.9747 | 1022.1387 | 326.1453 | 1689.027 | 1325.9702 | 1200.1192 | 1082.594 | 1042.7842 | 359.0463 | 16013.3653
100121 | 605.6882 | 4469.8293 | 1176.9962 | 3339.8645 | 2483.9475 | 5687.324999999999 | 35.53620000000012 | 3669.206 | 2880.0942 | 4869.2899 | 3704.299199999999 | 557.9145 | 33479.99069999999
100122 |  |  | 19.7299 |  |  |  |  | 824.1555000000001 |  |  | 462.5 |  | 1306.3854
100170 | 716.4518 | 664.3284 | 250.5906 | 610.8576999999999 | 598.5168 | 561.2844 | 496.6817 | 1371.3017 | 435.6 | 465.7698 | 2254.6875 | 763.125 | 9189.1954
100174 | 685.5926000000001 | 897.6357 | 352.4945 | 634.651 | 1273.1166 | 569.2372 | 1756.112999999999 | 2156.6858 | 1186.5437 | 738.5534 | 1278.7785 | 624.065 | 12153.467
100175 | 1443.0841 | 132.7363 | 482.707 | 1532.6924 | 1371.1914 | 1204.51 | 2785.9281 | 2842.6843 | 1126.4837 | 4004.0936 | -510.245 |  | 16415.8659
100180 | 634.62 | 279.1894 | 343.5696 | 168.9974 | 80.617 |  |  | 514.4955 |  | 28.1775 | 52.887 |  | 2102.5534
100220 |  | 554.1795 | 1570.1187 | 1041.12 | 1406.2275 | 1041.12 |  |  |  |  |  |  | 5612.7657
100225 |  |  |  | 85.8924 |  | 24.6094 |  |  |  |  |  |  | 110.5018
100240 | 1312.1667 | 2762.3109 | 1649.5516 | 1661.6826 | 1722.87 | 1221.754 | 1233.9729 | 1784.4405 | 1473.0624 | 2362.0258 | 1250.8312 | 69.375 | 18504.0436
100270 | 3648.940599999999 | 3523.2217 | 4418.7866 | 4541.950399999999 | 4744.589400000001 | 4618.3411 | 7976.088700000002 | 8951.6683 | 3859.3955 | 9481.113800000003 | 6186.164500000002 | 1660.9961 | 63611.25669999999
100280 | 6704.5411 | 5384.117 | 11653.3024 | 8516.756700000004 | 8103.523200000002 | 5438.443100000002 | 6403.455500000001 | 6658.3534 | 4155.921199999999 | 22879.4136 | 20032.5154 | 1085.4705 | 107015.8131
100290 | 48.5031 | 373.5414 | 379.1512 | 74.7945 | 248.646 | 255.5769 | 252.9414 | 416.7125 | 77.7 |  | 274.8305 | 108.6875 | 2511.085
431028 |  |  |  |  | 311.4171 |  |  |  |  |  |  |  | 311.4171
Grand Total | 101809.5634 | 102709.0185 | 120189.8714 | 115737.8898999999 | 120180.4557 | 115536.4497 | 135586.3964 | 142516.6114 | 84696.1395 | 149626.0554 | 131508.1501 | 34134.8622 | 1354231.4636