Spreadsheet: 140482d1328773573-pivot-table-calculation-test
Sheet: DataBase

Date | Customer | Rep | helper1 | helper2 | helper3
2012-01-02 00:00:00 | Cust1 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-02 00:00:00 | Cust2 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-02 00:00:00 | Cust3 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-02 00:00:00 | Cust4 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-02 00:00:00 | Cust5 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-02 00:00:00 | Cust6 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-03 00:00:00 | Cust7 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-03 00:00:00 | Cust8 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-03 00:00:00 | Cust9 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-03 00:00:00 | Cust10 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-03 00:00:00 | Cust11 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-04 00:00:00 | Cust12 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-04 00:00:00 | Cust13 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-04 00:00:00 | Cust14 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-04 00:00:00 | Cust15 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-04 00:00:00 | Cust16 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-05 00:00:00 | Cust17 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-05 00:00:00 | Cust18 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-05 00:00:00 | Cust19 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-05 00:00:00 | Cust20 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-05 00:00:00 | Cust21 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-05 00:00:00 | Cust22 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-05 00:00:00 | Cust23 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-05 00:00:00 | Cust24 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-06 00:00:00 | Cust25 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-06 00:00:00 | Cust26 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-06 00:00:00 | Cust27 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-06 00:00:00 | Cust28 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-06 00:00:00 | Cust29 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-06 00:00:00 | Cust30 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-09 00:00:00 | Cust31 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-09 00:00:00 | Cust32 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-09 00:00:00 | Cust33 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-09 00:00:00 | Cust34 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-11 00:00:00 | Cust35 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-11 00:00:00 | Cust36 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-11 00:00:00 | Cust37 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-11 00:00:00 | Cust38 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-11 00:00:00 | Cust39 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-12 00:00:00 | [NAME] | [NAME] | 17 | 62 | 3.647058823529412
2012-01-12 00:00:00 | Cust41 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-12 00:00:00 | [NAME] | [NAME] | 17 | 62 | 3.647058823529412
2012-01-13 00:00:00 | Cust43 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-13 00:00:00 | Cust44 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-16 00:00:00 | Cust45 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-17 00:00:00 | Cust46 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-18 00:00:00 | Cust47 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-19 00:00:00 | Cust48 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-23 00:00:00 | Cust49 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-23 00:00:00 | Cust50 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-23 00:00:00 | Cust51 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-23 00:00:00 | Cust52 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-24 00:00:00 | Cust53 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-25 00:00:00 | Cust54 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-25 00:00:00 | Cust55 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-25 00:00:00 | Cust56 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-25 00:00:00 | Cust57 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-25 00:00:00 | Cust58 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-25 00:00:00 | Cust59 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-25 00:00:00 | Cust60 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-25 00:00:00 | Cust61 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-27 00:00:00 | Cust62 | [NAME] | 17 | 62 | 3.647058823529412
2012-01-02 00:00:00 | [NAME] | [NAME] | 17 | 57 | 3.352941176470588
2012-01-02 00:00:00 | [NAME] | [NAME] | 17 | 57 | 3.352941176470588
2012-01-02 00:00:00 | Cust65 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-02 00:00:00 | Cust66 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-02 00:00:00 | Cust67 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-02 00:00:00 | Cust68 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-03 00:00:00 | Cust69 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-03 00:00:00 | Cust70 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-03 00:00:00 | Cust71 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-03 00:00:00 | Cust72 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-03 00:00:00 | Cust73 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-04 00:00:00 | [NAME] | [NAME] | 17 | 57 | 3.352941176470588
2012-01-04 00:00:00 | Cust75 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-04 00:00:00 | Cust76 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-04 00:00:00 | Cust77 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-04 00:00:00 | [NAME] | [NAME] | 17 | 57 | 3.352941176470588
2012-01-05 00:00:00 | Cust79 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-05 00:00:00 | Cust80 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-05 00:00:00 | Cust81 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-05 00:00:00 | Cust82 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-05 00:00:00 | Cust83 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-05 00:00:00 | Cust84 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-05 00:00:00 | Cust85 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-05 00:00:00 | Cust86 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-06 00:00:00 | Cust87 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-06 00:00:00 | Cust88 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-06 00:00:00 | [NAME] | [NAME] | 17 | 57 | 3.352941176470588
2012-01-06 00:00:00 | Cust90 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-06 00:00:00 | Cust91 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-06 00:00:00 | Cust92 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-09 00:00:00 | Cust93 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-09 00:00:00 | Cust94 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-09 00:00:00 | Cust95 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-09 00:00:00 | Cust96 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-11 00:00:00 | Cust97 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-11 00:00:00 | Cust98 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-11 00:00:00 | Cust99 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-11 00:00:00 | Cust100 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-11 00:00:00 | Cust101 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-16 00:00:00 | Cust107 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-17 00:00:00 | Cust108 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-18 00:00:00 | Cust109 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-19 00:00:00 | Cust110 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-23 00:00:00 | Cust111 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-23 00:00:00 | Cust112 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-23 00:00:00 | Cust113 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-23 00:00:00 | Cust114 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-24 00:00:00 | Cust115 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-25 00:00:00 | Cust116 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-25 00:00:00 | Cust117 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-25 00:00:00 | Cust118 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-25 00:00:00 | Cust119 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-25 00:00:00 | Cust120 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-25 00:00:00 | Cust121 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-25 00:00:00 | Cust122 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-25 00:00:00 | Cust123 | [NAME] | 17 | 57 | 3.352941176470588
2012-01-27 00:00:00 | Cust124 | [NAME] | 17 | 57 | 3.352941176470588
2012-02-06 00:00:00 | Cust1 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-06 00:00:00 | Cust2 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-06 00:00:00 | Cust3 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-07 00:00:00 | Cust4 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-07 00:00:00 | Cust5 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-07 00:00:00 | Cust6 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-07 00:00:00 | Cust7 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-07 00:00:00 | Cust8 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-07 00:00:00 | Cust9 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-08 00:00:00 | Cust10 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-08 00:00:00 | Cust11 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-09 00:00:00 | Cust12 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-09 00:00:00 | Cust13 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-09 00:00:00 | Cust14 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-09 00:00:00 | Cust15 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-09 00:00:00 | Cust16 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-10 00:00:00 | Cust17 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-10 00:00:00 | Cust18 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-10 00:00:00 | Cust19 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-10 00:00:00 | Cust20 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-13 00:00:00 | Cust21 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-13 00:00:00 | Cust22 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-13 00:00:00 | Cust23 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-13 00:00:00 | Cust24 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-13 00:00:00 | Cust25 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-13 00:00:00 | Cust26 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-14 00:00:00 | Cust27 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-14 00:00:00 | Cust65 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-14 00:00:00 | Cust66 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-15 00:00:00 | Cust67 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-15 00:00:00 | Cust68 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-15 00:00:00 | Cust69 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-15 00:00:00 | Cust70 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-16 00:00:00 | Cust71 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-16 00:00:00 | Cust72 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-16 00:00:00 | Cust73 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-16 00:00:00 | [NAME] | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-17 00:00:00 | Cust75 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-17 00:00:00 | Cust76 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-22 00:00:00 | Cust77 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-22 00:00:00 | [NAME] | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-22 00:00:00 | Cust79 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-22 00:00:00 | Cust80 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-22 00:00:00 | Cust81 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-22 00:00:00 | Cust82 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-23 00:00:00 | Cust83 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-23 00:00:00 | Cust84 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-23 00:00:00 | Cust85 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-23 00:00:00 | Cust86 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-23 00:00:00 | Cust87 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-23 00:00:00 | Cust88 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-23 00:00:00 | [NAME] | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-23 00:00:00 | Cust90 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-23 00:00:00 | Cust91 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-24 00:00:00 | Cust92 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-24 00:00:00 | Cust93 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-24 00:00:00 | Cust94 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-24 00:00:00 | Cust95 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-24 00:00:00 | Cust96 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-24 00:00:00 | Cust97 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-24 00:00:00 | Cust98 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-24 00:00:00 | Cust99 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-29 00:00:00 | Cust100 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-29 00:00:00 | Cust101 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-29 00:00:00 | Cust107 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-29 00:00:00 | Cust108 | [NAME] | 13.99999999999999 | 34 | 2.42857142857143
2012-02-29 00:00:00 | Cust109 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-29 00:00:00 | Cust110 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-29 00:00:00 | Cust111 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573
2012-02-29 00:00:00 | Cust112 | [NAME] | 13.99999999999999 | 36 | 2.571428571428573