Spreadsheet: 289411d1389568279-need-to-structure-my-data-properly-but-out-of-ideas-data-set-example-ndv-v2
Sheet: Sheet4

Date | Region | Team | Person | Sum of Sales | Sum of Commission | Sum of Revenue
2010-01-01 00:00:00 | London | Sales A | A | 49 | 0.05 | 2.45
 |  |  | B | 61 | 0.03 | 1.83
 |  | Sales A Total |  | 110 | 0.08 | 4.28
 | London Total |  |  | 110 | 0.08 | 4.28
Jan-10 Total |  |  |  | 110 | 0.08 | 4.28
2010-02-01 00:00:00 | London | Sales A | A | 1 | 0.03 | 0.03
 |  |  | B | 24 | 0.08 | 1.92
 |  | Sales A Total |  | 25 | 0.11 | 1.95
 | London Total |  |  | 25 | 0.11 | 1.95
Feb-10 Total |  |  |  | 25 | 0.11 | 1.95
2010-03-01 00:00:00 | London | Sales A | A | 9 | 0.05 | 0.45
 |  |  | B | 65 | 0.04 | 2.6
 |  | Sales A Total |  | 74 | 0.09 | 3.05
 | London Total |  |  | 74 | 0.09 | 3.05
Mar-10 Total |  |  |  | 74 | 0.09 | 3.05
2010-04-01 00:00:00 | London | Sales A | A | 49 | 0.1 | 4.9
 |  |  | B | 78 | 0.02 | 1.56
 |  | Sales A Total |  | 127 | 0.12 | 6.460000000000001
 | London Total |  |  | 127 | 0.12 | 6.460000000000001
Apr-10 Total |  |  |  | 127 | 0.12 | 6.460000000000001
2010-05-01 00:00:00 | London | Sales A | A |  |  | 0
 |  |  | B |  |  | 0
 |  | Sales A Total |  |  |  | 0
 | London Total |  |  |  |  | 0
May-10 Total |  |  |  |  |  | 0
2010-06-01 00:00:00 | London | Sales A | A | 93 | 0 | 0
 |  |  | B | 10 | 0.07 | 0.7000000000000001
 |  | Sales A Total |  | 103 | 0.07 | 0.7000000000000001
 | London Total |  |  | 103 | 0.07 | 0.7000000000000001
Jun-10 Total |  |  |  | 103 | 0.07 | 0.7000000000000001
2010-07-01 00:00:00 | London | Sales A | A | 11 | 0 | 0
 |  |  | B | 94 | 0.05 | 4.7
 |  | Sales A Total |  | 105 | 0.05 | 4.7
 | London Total |  |  | 105 | 0.05 | 4.7
Jul-10 Total |  |  |  | 105 | 0.05 | 4.7
2010-08-01 00:00:00 | London | Sales A | A | 59 | 0.01 | 0.59
 |  |  | B | 74 | 0.06 | 4.44
 |  | Sales A Total |  | 133 | 0.06999999999999999 | 5.029999999999999
 | London Total |  |  | 133 | 0.06999999999999999 | 5.029999999999999
Aug-10 Total |  |  |  | 133 | 0.06999999999999999 | 5.029999999999999
2010-09-01 00:00:00 | London | Sales A | A | 14 | 0.09 | 1.26
 |  |  | B | 66 | 0.05 | 3.3
 |  | Sales A Total |  | 80 | 0.14 | 4.56
 | London Total |  |  | 80 | 0.14 | 4.56
Sep-10 Total |  |  |  | 80 | 0.14 | 4.56
2010-10-01 00:00:00 | London | Sales A | A | 20 | 0.08 | 1.6
 |  |  | B | 3 | 0.01 | 0.03
 |  | Sales A Total |  | 23 | 0.09 | 1.63
 | London Total |  |  | 23 | 0.09 | 1.63
Oct-10 Total |  |  |  | 23 | 0.09 | 1.63
2010-11-01 00:00:00 | London | Sales A | A | 15 | 0.02 | 0.3
 |  |  | B | 47 | 0 | 0
 |  | Sales A Total |  | 62 | 0.02 | 0.3
 | London Total |  |  | 62 | 0.02 | 0.3
Nov-10 Total |  |  |  | 62 | 0.02 | 0.3
2010-12-01 00:00:00 | London | Sales A | A | 59 | 0.04 | 2.36
 |  |  | B | 18 | 0.01 | 0.18
 |  | Sales A Total |  | 77 | 0.05 | 2.54
 | London Total |  |  | 77 | 0.05 | 2.54
Dec-10 Total |  |  |  | 77 | 0.05 | 2.54
2011-01-01 00:00:00 | London | Sales A | A | 49 | 0.04 | 1.96
 |  |  | B | 61 | 0.08 | 4.88
 |  | Sales A Total |  | 110 | 0.12 | 6.84
 | London Total |  |  | 110 | 0.12 | 6.84
Jan-11 Total |  |  |  | 110 | 0.12 | 6.84
2011-02-01 00:00:00 | London | Sales A | A | 1 | 0.1 | 0.1
 |  |  | B | 24 | 0.09 | 2.16
 |  | Sales A Total |  | 25 | 0.19 | 2.26
 | London Total |  |  | 25 | 0.19 | 2.26
Feb-11 Total |  |  |  | 25 | 0.19 | 2.26
2011-03-01 00:00:00 | London | Sales A | A | 9 | 0.04 | 0.36
 |  |  | B | 65 | 0.07 | 4.550000000000001
 |  | Sales A Total |  | 74 | 0.11 | 4.910000000000001
 | London Total |  |  | 74 | 0.11 | 4.910000000000001
Mar-11 Total |  |  |  | 74 | 0.11 | 4.910000000000001
2011-04-01 00:00:00 | London | Sales A | A | 49 | 0 | 0
 |  |  | B | 78 | 0.05 | 3.9
 |  | Sales A Total |  | 127 | 0.05 | 3.9
 | London Total |  |  | 127 | 0.05 | 3.9
Apr-11 Total |  |  |  | 127 | 0.05 | 3.9
2011-05-01 00:00:00 | London | Sales A | A |  |  | 0
 |  |  | B |  |  | 0
 |  | Sales A Total |  |  |  | 0
 | London Total |  |  |  |  | 0
May-11 Total |  |  |  |  |  | 0
2011-06-01 00:00:00 | London | Sales A | A | 93 | 0.1 | 9.3
 |  |  | B | 10 | 0.1 | 1
 |  | Sales A Total |  | 103 | 0.2 | 10.3
 | London Total |  |  | 103 | 0.2 | 10.3
Jun-11 Total |  |  |  | 103 | 0.2 | 10.3
2011-07-01 00:00:00 | London | Sales A | A | 11 | 0.02 | 0.22
 |  |  | B | 94 | 0.05 | 4.7
 |  | Sales A Total |  | 105 | 0.07 | 4.92
 | London Total |  |  | 105 | 0.07 | 4.92
Jul-11 Total |  |  |  | 105 | 0.07 | 4.92
2011-08-01 00:00:00 | London | Sales A | A | 59 | 0.04 | 2.36
 |  |  | B | 74 | 0.07 | 5.180000000000001
 |  | Sales A Total |  | 133 | 0.11 | 7.540000000000001
 | London Total |  |  | 133 | 0.11 | 7.540000000000001
Aug-11 Total |  |  |  | 133 | 0.11 | 7.540000000000001
2011-09-01 00:00:00 | London | Sales A | A | 14 | 0.01 | 0.14
 |  |  | B | 66 | 0.09 | 5.94
 |  | Sales A Total |  | 80 | 0.09999999999999999 | 6.079999999999999
 | London Total |  |  | 80 | 0.09999999999999999 | 6.079999999999999
Sep-11 Total |  |  |  | 80 | 0.09999999999999999 | 6.079999999999999
2011-10-01 00:00:00 | London | Sales A | A | 20 | 0.1 | 2
 |  |  | B | 3 | 0.07 | 0.21
 |  | Sales A Total |  | 23 | 0.17 | 2.21
 | London Total |  |  | 23 | 0.17 | 2.21
Oct-11 Total |  |  |  | 23 | 0.17 | 2.21
2011-11-01 00:00:00 | London | Sales A | A | 15 | 0.01 | 0.15
 |  |  | B | 47 | 0.06 | 2.82
 |  | Sales A Total |  | 62 | 0.06999999999999999 | 2.97
 | London Total |  |  | 62 | 0.06999999999999999 | 2.97
Nov-11 Total |  |  |  | 62 | 0.06999999999999999 | 2.97
2011-12-01 00:00:00 | London | Sales A | A | 59 | 0.03 | 1.77
 |  |  | B | 18 | 0.04 | 0.72
 |  | Sales A Total |  | 77 | 0.07 | 2.49
 | London Total |  |  | 77 | 0.07 | 2.49
Dec-11 Total |  |  |  | 77 | 0.07 | 2.49
Grand Total |  |  |  | 1838 | 2.150000000000001 | 89.62