Spreadsheet: 140312d1328702147-calculate-formula-in-pivot-table-test
Sheet: Pivot

Row Labels | Sum of Send outs | Sum of Bounces | Sum of Openings (Total) | Sum of Openings (unique) | Sum of Clicks (total) | Sum of Clicks (unique) | Sum of Unsubscribers | Recipients | Openers | Clickers | Unsubscribers
2012-01-01 00:00:00 | 902 | 8 | 355 | 239 | 8 | 4 | 1
A | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 7 | 0 | 3 | 2 | 0 | 0 | 0
C | 3 | 0 | 0 | 0 | 0 | 0 | 0
D | 1 | 0 | 1 | 1 | 0 | 0 | 0
E | 29 | 0 | 10 | 8 | 1 | 1 | 0
F | 7 | 1 | 7 | 4 | 5 | 1 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 855 | 7 | 334 | 224 | 2 | 2 | 1
2012-01-02 00:00:00 | 87 | 2 | 51 | 30 | 7 | 5 | 1
A | 2 | 0 | 1 | 1 | 0 | 0 | 0
B | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 9 | 1 | 2 | 2 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 69 | 1 | 46 | 25 | 6 | 4 | 0
G | 1 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 6 | 0 | 2 | 2 | 1 | 1 | 1
2012-01-03 00:00:00 | 54 | 1 | 39 | 17 | 3 | 3 | 0
A | 2 | 0 | 1 | 1 | 0 | 0 | 0
B | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 23 | 1 | 8 | 7 | 1 | 1 | 0
E | 8 | 0 | 6 | 4 | 1 | 1 | 0
F | 1 | 0 | 0 | 0 | 0 | 0 | 0
G | 2 | 0 | 0 | 0 | 0 | 0 | 0
H | 18 | 0 | 24 | 5 | 1 | 1 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-04 00:00:00 | 50 | 0 | 34 | 15 | 0 | 0 | 0
A | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 3 | 0 | 2 | 1 | 0 | 0 | 0
C | 3 | 0 | 5 | 2 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 9 | 0 | 1 | 1 | 0 | 0 | 0
F | 19 | 0 | 21 | 8 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 16 | 0 | 5 | 3 | 0 | 0 | 0
2012-01-05 00:00:00 | 57 | 0 | 29 | 13 | 9 | 3 | 0
A | 1 | 0 | 0 | 0 | 0 | 0 | 0
B | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 13 | 0 | 15 | 4 | 1 | 1 | 0
D | 33 | 0 | 5 | 5 | 0 | 0 | 0
E | 3 | 0 | 4 | 2 | 5 | 1 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0
G | 1 | 0 | 0 | 0 | 0 | 0 | 0
H | 1 | 0 | 0 | 0 | 0 | 0 | 0
I | 5 | 0 | 5 | 2 | 3 | 1 | 0
2012-01-06 00:00:00 | 226 | 1 | 118 | 77 | 12 | 10 | 0
A | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 11 | 0 | 8 | 5 | 0 | 0 | 0
C | 9 | 0 | 5 | 4 | 0 | 0 | 0
D | 6 | 1 | 2 | 1 | 0 | 0 | 0
E | 1 | 0 | 0 | 0 | 0 | 0 | 0
F | 144 | 0 | 68 | 45 | 7 | 6 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 55 | 0 | 35 | 22 | 5 | 4 | 0
2012-01-07 00:00:00 | 52 | 0 | 29 | 18 | 0 | 0 | 0
A | 15 | 0 | 13 | 6 | 0 | 0 | 0
B | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 6 | 0 | 4 | 2 | 0 | 0 | 0
E | 5 | 0 | 3 | 2 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 2 | 0 | 0 | 0 | 0 | 0 | 0
I | 24 | 0 | 9 | 8 | 0 | 0 | 0
2012-01-08 00:00:00 | 66 | 0 | 29 | 20 | 1 | 1 | 0
A | 15 | 0 | 5 | 5 | 0 | 0 | 0
B | 1 | 0 | 5 | 1 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 8 | 0 | 3 | 3 | 0 | 0 | 0
E | 2 | 0 | 0 | 0 | 0 | 0 | 0
F | 2 | 0 | 2 | 1 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 35 | 0 | 13 | 9 | 1 | 1 | 0
I | 3 | 0 | 1 | 1 | 0 | 0 | 0
2012-01-09 00:00:00 | 18 | 0 | 6 | 5 | 1 | 1 | 0
A | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 6 | 0 | 0 | 0 | 0 | 0 | 0
C | 2 | 0 | 1 | 1 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0
G | 4 | 0 | 2 | 1 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 6 | 0 | 3 | 3 | 1 | 1 | 0
2012-01-10 00:00:00 | 6805 | 25 | 5670 | 2842 | 959 | 655 | 5
A | 6773 | 25 | 5640 | 2832 | 957 | 653 | 5
B | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 5 | 0 | 0 | 0 | 0 | 0 | 0
D | 4 | 0 | 7 | 3 | 0 | 0 | 0
E | 2 | 0 | 1 | 1 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 21 | 0 | 22 | 6 | 2 | 2 | 0
2012-01-11 00:00:00 | 25 | 0 | 17 | 10 | 1 | 1 | 0
A | 4 | 0 | 4 | 3 | 1 | 1 | 0
B | 2 | 0 | 2 | 1 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 2 | 0 | 1 | 1 | 0 | 0 | 0
E | 6 | 0 | 7 | 3 | 0 | 0 | 0
F | 11 | 0 | 3 | 2 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-12 00:00:00 | 99165 | 713 | 24065 | 15353 | 1051 | 796 | 521
A | 25 | 0 | 9 | 6 | 3 | 2 | 0
B | 99089 | 713 | 24034 | 15332 | 1046 | 792 | 521
C | 5 | 0 | 2 | 2 | 0 | 0 | 0
D | 2 | 0 | 0 | 0 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 41 | 0 | 19 | 12 | 2 | 2 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 1 | 0 | 0 | 0 | 0 | 0 | 0
I | 2 | 0 | 1 | 1 | 0 | 0 | 0
2012-01-13 00:00:00 | 385 | 3 | 234 | 123 | 30 | 22 | 1
A | 26 | 0 | 11 | 7 | 0 | 0 | 0
B | 342 | 3 | 215 | 112 | 30 | 22 | 1
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 8 | 0 | 5 | 3 | 0 | 0 | 0
E | 1 | 0 | 0 | 0 | 0 | 0 | 0
F | 2 | 0 | 3 | 1 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 6 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-14 00:00:00 | 61 | 0 | 41 | 22 | 4 | 4 | 1
A | 10 | 0 | 5 | 3 | 0 | 0 | 0
B | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 15 | 0 | 7 | 6 | 1 | 1 | 0
E | 6 | 0 | 0 | 0 | 0 | 0 | 0
F | 3 | 0 | 1 | 1 | 0 | 0 | 0
G | 27 | 0 | 28 | 12 | 3 | 3 | 1
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-15 00:00:00 | 41 | 0 | 44 | 13 | 1 | 1 | 0
A | 13 | 0 | 34 | 5 | 0 | 0 | 0
B | 4 | 0 | 1 | 1 | 1 | 1 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 10 | 0 | 4 | 3 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 7 | 0 | 2 | 1 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 7 | 0 | 3 | 3 | 0 | 0 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-16 00:00:00 | 27 | 0 | 17 | 7 | 0 | 0 | 0
A | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 10 | 0 | 1 | 1 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 4 | 0 | 3 | 1 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0
G | 2 | 0 | 1 | 1 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 11 | 0 | 12 | 4 | 0 | 0 | 0
2012-01-17 00:00:00 | 78 | 1 | 48 | 23 | 6 | 5 | 0
A | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 28 | 0 | 37 | 15 | 4 | 4 | 0
C | 1 | 0 | 0 | 0 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 4 | 0 | 0 | 0 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0
G | 1 | 0 | 0 | 0 | 0 | 0 | 0
H | 40 | 1 | 9 | 7 | 2 | 1 | 0
I | 4 | 0 | 2 | 1 | 0 | 0 | 0
2012-01-18 00:00:00 | 38 | 0 | 16 | 12 | 10 | 2 | 0
A | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 2 | 0 | 1 | 1 | 3 | 1 | 0
C | 4 | 0 | 2 | 1 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 2 | 0 | 1 | 1 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 13 | 0 | 7 | 5 | 7 | 1 | 0
I | 17 | 0 | 5 | 4 | 0 | 0 | 0
2012-01-19 00:00:00 | 97 | 2 | 250 | 38 | 5 | 5 | 0
A | 3 | 0 | 5 | 2 | 1 | 1 | 0
B | 1 | 0 | 0 | 0 | 0 | 0 | 0
C | 28 | 0 | 13 | 10 | 1 | 1 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 36 | 0 | 219 | 19 | 3 | 3 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 24 | 2 | 8 | 6 | 0 | 0 | 0
I | 5 | 0 | 5 | 1 | 0 | 0 | 0
2012-01-20 00:00:00 | 203 | 1 | 95 | 61 | 14 | 12 | 0
A | 91 | 0 | 29 | 19 | 3 | 3 | 0
B | 48 | 1 | 32 | 21 | 6 | 5 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 32 | 0 | 12 | 10 | 1 | 1 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 28 | 0 | 22 | 11 | 4 | 3 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 4 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-21 00:00:00 | 433 | 7 | 186 | 133 | 31 | 24 | 1
A | 1 | 0 | 0 | 0 | 0 | 0 | 0
B | 304 | 4 | 136 | 95 | 29 | 22 | 0
C | 65 | 3 | 29 | 22 | 1 | 1 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 7 | 0 | 9 | 5 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 48 | 0 | 9 | 8 | 1 | 1 | 1
I | 8 | 0 | 3 | 3 | 0 | 0 | 0
2012-01-22 00:00:00 | 270 | 3 | 167 | 106 | 11 | 9 | 0
A | 16 | 0 | 12 | 8 | 0 | 0 | 0
B | 204 | 3 | 134 | 81 | 11 | 9 | 0
C | 1 | 0 | 0 | 0 | 0 | 0 | 0
D | 42 | 0 | 15 | 13 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 2 | 0 | 1 | 1 | 0 | 0 | 0
G | 4 | 0 | 5 | 3 | 0 | 0 | 0
H | 1 | 0 | 0 | 0 | 0 | 0 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-23 00:00:00 | 20 | 0 | 10 | 7 | 1 | 1 | 0
A | 2 | 0 | 1 | 1 | 0 | 0 | 0
B | 4 | 0 | 2 | 1 | 1 | 1 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 8 | 0 | 4 | 2 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0
G | 6 | 0 | 3 | 3 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-24 00:00:00 | 79 | 0 | 61 | 30 | 22 | 5 | 0
A | 0 | 0 | 0 | 0 | 0 | 0 | 0
B | 5 | 0 | 1 | 1 | 0 | 0 | 0
C | 23 | 0 | 14 | 10 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 2 | 0 | 1 | 1 | 0 | 0 | 0
F | 24 | 0 | 8 | 7 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 25 | 0 | 37 | 11 | 22 | 5 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-25 00:00:00 | 83 | 0 | 46 | 27 | 4 | 4 | 0
A | 15 | 0 | 9 | 6 | 2 | 2 | 0
B | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 60 | 0 | 29 | 17 | 1 | 1 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 5 | 0 | 7 | 3 | 1 | 1 | 0
I | 3 | 0 | 1 | 1 | 0 | 0 | 0
2012-01-26 00:00:00 | 97 | 0 | 91 | 32 | 2 | 2 | 0
A | 6 | 0 | 9 | 3 | 0 | 0 | 0
B | 52 | 0 | 68 | 18 | 2 | 2 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 6 | 0 | 4 | 4 | 0 | 0 | 0
E | 0 | 0 | 0 | 0 | 0 | 0 | 0
F | 31 | 0 | 10 | 7 | 0 | 0 | 0
G | 2 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-27 00:00:00 | 717 | 7 | 402 | 212 | 26 | 20 | 2
A | 110 | 0 | 73 | 43 | 7 | 4 | 0
B | 555 | 6 | 310 | 157 | 19 | 16 | 2
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 14 | 1 | 6 | 2 | 0 | 0 | 0
E | 2 | 0 | 0 | 0 | 0 | 0 | 0
F | 0 | 0 | 0 | 0 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 25 | 0 | 10 | 7 | 0 | 0 | 0
I | 11 | 0 | 3 | 3 | 0 | 0 | 0
2012-01-28 00:00:00 | 147 | 0 | 58 | 38 | 2 | 2 | 0
A | 59 | 0 | 23 | 13 | 0 | 0 | 0
B | 1 | 0 | 0 | 0 | 0 | 0 | 0
C | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 46 | 0 | 14 | 14 | 0 | 0 | 0
E | 3 | 0 | 5 | 3 | 1 | 1 | 0
F | 8 | 0 | 1 | 1 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 30 | 0 | 15 | 7 | 1 | 1 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-29 00:00:00 | 8334 | 45 | 5402 | 2985 | 545 | 416 | 6
A | 4 | 0 | 1 | 1 | 0 | 0 | 0
B | 52 | 0 | 49 | 16 | 0 | 0 | 0
C | 8139 | 44 | 5246 | 2903 | 535 | 407 | 6
D | 2 | 0 | 0 | 0 | 0 | 0 | 0
E | 74 | 0 | 50 | 31 | 1 | 1 | 0
F | 2 | 0 | 0 | 0 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 61 | 1 | 56 | 34 | 9 | 8 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-30 00:00:00 | 64 | 1 | 36 | 21 | 1 | 1 | 0
A | 2 | 0 | 0 | 0 | 0 | 0 | 0
B | 1 | 0 | 0 | 0 | 0 | 0 | 0
C | 3 | 0 | 8 | 3 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 7 | 0 | 1 | 1 | 0 | 0 | 0
F | 5 | 0 | 1 | 1 | 0 | 0 | 0
G | 1 | 0 | 1 | 1 | 0 | 0 | 0
H | 45 | 1 | 25 | 15 | 1 | 1 | 0
I | 0 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-31 00:00:00 | 50 | 0 | 35 | 21 | 0 | 0 | 0
A | 3 | 0 | 3 | 2 | 0 | 0 | 0
B | 0 | 0 | 0 | 0 | 0 | 0 | 0
C | 28 | 0 | 20 | 10 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0
E | 7 | 0 | 3 | 3 | 0 | 0 | 0
F | 5 | 0 | 2 | 2 | 0 | 0 | 0
G | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 0 | 0 | 0 | 0 | 0 | 0 | 0
I | 7 | 0 | 7 | 4 | 0 | 0 | 0
Grand Total | 118731 | 820 | 37681 | 22550 | 2767 | 2014 | 539