Spreadsheet: 111772d1308074261-create-pivot-table-callpivottable
Sheet: desired display

 |  | Agent1 | Agent2 | Agent3 | Agent4 | Agent5 | Agent6
Jan | Calls Handled | 157 | 340 | 236 | 178 | 532 | 1443
 | Calls Presented | 181 | 352 | 275 | 242 | 552 | 1602
 | Handle Ratio | 0.8674 | 0.9659 | 0.8582 | 0.7355 | 0.9638 | 0.9007
Feb | Calls Handled | 117 | 280 | 288 | 129 | 530 | 1344
 | Calls Presented | 130 | 289 | 319 | 155 | 547 | 1440
 | Handle Ratio | 0.9 | 0.9689 | 0.9028 | 0.8323 | 0.9689 | 0.9333
Sum of Calls Handled | Column Labels
Row Labels | Agent 1 | Agent 2 | Agent 3 | Agent 4 | Agent 5 | Agent 6 | Grand Total
2010-07-01 00:00:00 | 531.95 | 268.9 | 601.91 | 421.97 | 785.97 | 380.85 | 2991.55
Calls Handled | 259 | 127 | 286 | 207 | 386 | 175 | 1440
Calls Presented | 272 | 141 | 315 | 214 | 399 | 205 | 1546
Handle Ratio | 0.95 | 0.9 | 0.91 | 0.97 | 0.97 | 0.85 | 5.55
2010-08-01 00:00:00 | 487.92 | 379.91 | 310.95 | 568.96 | 532.95 | 418.82 | 2699.51
Calls Handled | 233 | 181 | 151 | 278 | 259 | 188 | 1290
Calls Presented | 254 | 198 | 159 | 290 | 273 | 230 | 1404
Handle Ratio | 0.92 | 0.91 | 0.95 | 0.96 | 0.95 | 0.82 | 5.510000000000001
2010-09-01 00:00:00 | 589.94 | 192.94 | 496.95 | 386.96 | 698.98 | 477.87 | 2843.64
Calls Handled | 286 | 93 | 241 | 189 | 345 | 222 | 1376
Calls Presented | 303 | 99 | 255 | 197 | 353 | 255 | 1462
Handle Ratio | 0.94 | 0.94 | 0.95 | 0.96 | 0.98 | 0.87 | 5.64
2010-10-01 00:00:00 | 778.95 | 332.95 | 545.95 | 614.96 | 639.98 | 511.87 | 3424.66
Calls Handled | 378 | 162 | 266 | 301 | 316 | 238 | 1661
Calls Presented | 400 | 170 | 279 | 313 | 323 | 273 | 1758
Handle Ratio | 0.95 | 0.95 | 0.95 | 0.96 | 0.98 | 0.87 | 5.659999999999999
2010-11-01 00:00:00 | 681.92 | 258.88 | 615.96 | 643.95 | 430.99 | 619.88 | 3251.58
Calls Handled | 326 | 121 | 301 | 313 | 214 | 290 | 1565
Calls Presented | 355 | 137 | 314 | 330 | 216 | 329 | 1681
Handle Ratio | 0.92 | 0.88 | 0.96 | 0.95 | 0.99 | 0.88 | 5.58
2010-12-01 00:00:00 | 697.93 | 237.88 | 538.96 | 579.93 | 568.95 | 415.87 | 3039.52
Calls Handled | 335 | 111 | 264 | 279 | 277 | 193 | 1459
Calls Presented | 362 | 126 | 274 | 300 | 291 | 222 | 1575
Handle Ratio | 0.93 | 0.88 | 0.96 | 0.93 | 0.95 | 0.87 | 5.52
2011-01-01 00:00:00 | 722.93 | 352.87 | 712.95 | 633.98 | 700.97 | 523.85 | 3647.55
Calls Handled | 348 | 164 | 347 | 313 | 344 | 241 | 1757
Calls Presented | 374 | 188 | 365 | 320 | 356 | 282 | 1885
Handle Ratio | 0.93 | 0.87 | 0.95 | 0.98 | 0.97 | 0.85 | 5.55
2011-02-01 00:00:00 | 682.88 | 265.91 | 663.94 | 693.94 | 618.97 | 647.9 | 3573.54
Calls Handled | 320 | 126 | 321 | 336 | 304 | 307 | 1714
Calls Presented | 362 | 139 | 342 | 357 | 314 | 340 | 1854
Handle Ratio | 0.88 | 0.91 | 0.94 | 0.94 | 0.97 | 0.9 | 5.54
2011-03-01 00:00:00 | 864.89 | 257.9 | 846.94 | 832.96 | 1035.98 | 713.93 | 4552.6
Calls Handled | 408 | 122 | 410 | 408 | 511 | 343 | 2202
Calls Presented | 456 | 135 | 436 | 424 | 524 | 370 | 2345
Handle Ratio | 0.89 | 0.9 | 0.94 | 0.96 | 0.98 | 0.93 | 5.6
2011-04-01 00:00:00 | 718.89 | 184.8 | 685.92 | 605.95 | 775.98 | 702.94 | 3674.48
Calls Handled | 338 | 82 | 328 | 294 | 384 | 340 | 1766
Calls Presented | 380 | 102 | 357 | 311 | 391 | 362 | 1903
Handle Ratio | 0.89 | 0.8 | 0.92 | 0.95 | 0.98 | 0.94 | 5.479999999999999
2011-05-01 00:00:00 | 720.89 | 293.77 | 739.94 | 597.95 | 867.97 | 566.97 | 3787.49
Calls Handled | 339 | 127 | 358 | 291 | 427 | 278 | 1820
Calls Presented | 381 | 166 | 381 | 306 | 440 | 288 | 1962
Handle Ratio | 0.89 | 0.77 | 0.94 | 0.95 | 0.97 | 0.97 | 5.489999999999999
Grand Total | 7479.090000000001 | 3026.71 | 6760.369999999999 | 6581.509999999999 | 7657.69 | 5980.75 | 37486.12