Spreadsheet: 494051d1482151688-converting-eliminating-blank-cell-in-pivot-sample-19-chg1
Sheet: Temp Storage for Pivots

Sheet 1
ch32 - Uncontactable
Sum of %Uncontactable | Column Labels
Row Labels | Acquisitions | Business Banking | Cash Investments | Hunters | Supersize | Vault | Winers & Diners
2016-11-01 00:00:00 | 0.2720063609859528 | 0.264166724750819 | 0.4683827644096251 | 0.324543664876592 | 0.4530431937172775 | 0.328364569146314 | 0.3643695223145478
2016-12-01 00:00:00 | 0.2905483430731007 | 0.3038885142728703 | 0.5069637883008357 | 0.3962159411574224 | 0.4236690044550306 | 0.3526691784508489 | 0.3859863869878892
ch33 - Diarized
Sum of %Diarized | Column Labels
Row Labels | Acquisitions | Business Banking | Cash Investments | Hunters | Supersize | Vault | Winers & Diners
2016-11-01 00:00:00 | 0.1244314868804665 | 0.1495783090541577 | 0.1654542063047939 | 0.1749005638065648 | 0.1076297993019197 | 0.1710797871007094 | 0.1272387062282812
2016-12-01 00:00:00 | 0.1351786401651678 | 0.1359856147448865 | 0.1493036211699164 | 0.1649858907341444 | 0.1024215958713775 | 0.1630376278318736 | 0.1274689812496523
ch34 - Taken up
Sum of %Taken Up | Column Labels
Row Labels | Acquisitions | Business Banking | Cash Investments | Hunters | Supersize | Vault | Winers & Diners | (blank)
2016-11-01 00:00:00 | 0.07105221309302942 | 0.1445598382937199 | 0.08711061369147548 | 0.04811774316669122 | 0.1483965968586387 | 0.1080706210676716 | 0.1195152052870151
2016-12-01 00:00:00 | 0.06582216467788782 | 0.1357608451337379 | 0.083008356545961 | 0.04248970717490864 | 0.1498390013673856 | 0.13208885844302 | 0.09137780745191862
(blank)
ch36 - Not interested
Sum of %Not Interested | Column Labels
Row Labels | Acquisitions | Business Banking | Cash Investments | Hunters | Supersize | Vault | Winers & Diners | (blank)
2016-11-01 00:00:00 | 0.06682215743440233 | 0.06022164912525266 | 0.08505875769445999 | 0.1445741988188186 | 0.01058027923211169 | 0.09977356472623056 | 0.07525579120385378
2016-12-01 00:00:00 | 0.0784197081569094 | 0.04922454484153743 | 0.09916434540389972 | 0.1552250543553685 | 0.01221825239292488 | 0.09813084112149532 | 0.08336578942487806
(blank)
ch37 - Inquiry
Sum of %Enquiry | Column Labels
Row Labels | Acquisitions | Business Banking | Cash Investments | Hunters | Supersize | Vault | Winers & Diners
2016-11-01 00:00:00 | 0.003116883116883117 | 0.03108663832160033 | 0.02201081887707517 | 3.348019980983246e-05 | 0.03423592931937173 | 0.002916085259982788 | 0.0001308103988579683
2016-12-01 00:00:00 | 0.003009413164432935 | 0.02944481906046302 | 0.01337047353760446 | 0.0001387796641532127 | 0.034890388602179 | 0.001908303567059745 | 7.418535210222742e-05
ch38 - Disqualified
Sum of %Disqualified | Column Labels
Row Labels | Acquisitions | Business Banking | Cash Investments | Hunters | Supersize | Vault | Winers & Diners | (blank)
2016-11-01 00:00:00 | 0.03306652531142327 | 0.1391928626193629 | 0.01828017160977429 | 0.03285746809336958 | 0.1737429101221641 | 0.01692833448918375 | 0.02716306369328943
2016-12-01 00:00:00 | 0.04724078804633097 | 0.1665542818610924 | 0.0116991643454039 | 0.03541194430309479 | 0.2114595739049888 | 0.006679062484709106 | 0.03373578886848792
(blank)
Sheet 2
ch41 - Time spent per Outcome
Sum of Time Spent Per Outcome | Column Labels
Row Labels | Avg_TakenUpTime | Avg_NotInterestedTime | Avg_Diarized | Avg_UncontableTime | Avg_DisqualifiedTime | (blank)
2016-11-01 00:00:00 | 0:35:56 | 0:05:18 | 0:02:36 | 0:04:28 | 0:02:45
2016-12-01 00:00:00 | 0:32:36 | 0:05:11 | 0:02:18 | 0:04:18 | 0:02:36
(blank)
ch42 - Taken up Time
Sum of Taken Up Time | Column Labels
Row Labels | Acquisitions | Business Banking | Cash Investments | Hunters | Supersize | Vault | Winers & Diners
2016-11-01 00:00:00 | 1:12:58 | 1:12:00 | 0:25:23 | 0:53:58 | 0:42:58 | 0:23:44 | 0:18:32
2016-12-01 00:00:00 | 1:08:44 | 1:16:48 | 0:22:19 | 0:55:24 | 0:38:47 | 0:15:06 | 0:19:38
ch43 -Not interested Time
Sum of Not Interested Time | Column Labels
Row Labels | Acquisitions | Business Banking | Cash Investments | Hunters | Supersize | Vault | Winers & Diners | (blank) | Grand Total
42675 | 0:05:02 | 0:05:24 | 0:05:30 | 0:04:57 | 0:06:06 | 0:05:50 | 0:05:28 |  | 0:38:17
42705 | 0:04:43 | 0:05:41 | 0:07:31 | 0:04:50 | 0:06:25 | 0:05:11 | 0:05:18 |  | 0:39:39
(blank)
Grand Total | 0:09:45 | 0:11:05 | 0:13:01 | 0:09:47 | 0:12:31 | 0:11:01 | 0:10:46 |  | 1:17:56