Spreadsheet: 186263d1349970751-pivot-table-slicer-help-example-dashboard
Sheet: Data

Month | Duration | Spend | Total Calls | Service | Client
2010-10-01 00:00:00 | 61826 | 31531.26 | 7728.25 |  | Client 1
2010-11-01 00:00:00 | 64678 | 32985.78 | 8084.75 |  | Client 1
2010-12-01 00:00:00 | 73956 | 37717.56 | 9244.5 |  | Client 1
2011-01-01 00:00:00 | 59315 | 30250.65 | 7414.375 |  | Client 1
2011-02-01 00:00:00 | 55908 | 28513.08 | 6988.5 |  | Client 1
2011-03-01 00:00:00 | 61107 | 31164.57 | 7638.375 |  | Client 1
2011-04-01 00:00:00 | 66380 | 33853.8 | 8297.5 |  | Client 1 |  |  | Row Labels | Sum of Spend | Sum of Duration |  |  |  | Row Labels | Sum of Total Calls | Sum of Service
2011-05-01 00:00:00 | 54096 | 27588.96 | 6762 | 0.9091 | Client 1 |  |  | Client 1 | 728211.1499999999 | 1427865 |  |  |  | Client 1 | 178483.125 | 23.1467
2011-06-01 00:00:00 | 50063 | 25532.13 | 6257.875 | 0.9305 | Client 1 |  |  | 2010-10-01 00:00:00 | 31531.26 | 61826 |  |  |  | 2010-10-01 00:00:00 | 7728.25 | 0.99
2011-07-01 00:00:00 | 61158 | 31190.58 | 7644.75 | 0.9073 | Client 1 |  |  | 2010-11-01 00:00:00 | 32985.78 | 64678 |  |  |  | 2010-11-01 00:00:00 | 8084.75 | 0.99
2011-08-01 00:00:00 | 65656 | 33484.56 | 8207 | 0.9377 | Client 1 |  |  | 2010-12-01 00:00:00 | 37717.56 | 73956 |  |  |  | 2010-12-01 00:00:00 | 9244.5 | 0.99
2011-09-01 00:00:00 | 58411 | 29789.61 | 7301.375 | 0.9575 | Client 1 |  |  | 2011-01-01 00:00:00 | 30250.65 | 59315 |  |  |  | 2011-01-01 00:00:00 | 7414.375 | 0.99
2011-10-01 00:00:00 | 53670 | 27371.7 | 6708.75 | 0.9713 | Client 1 |  |  | 2011-02-01 00:00:00 | 28513.08 | 55908 |  |  |  | 2011-02-01 00:00:00 | 6988.5 | 0.99
2011-11-01 00:00:00 | 69921 | 35659.71 | 8740.125 | 0.948 | Client 1 |  |  | 2011-03-01 00:00:00 | 31164.57 | 61107 |  |  |  | 2011-03-01 00:00:00 | 7638.375 | 0.99
2011-12-01 00:00:00 | 51228 | 26126.28 | 6403.5 | 0.9262 | Client 1 |  |  | 2011-04-01 00:00:00 | 33853.8 | 66380 |  |  |  | 2011-04-01 00:00:00 | 8297.5 | 0.99
2012-01-01 00:00:00 | 52106 | 26574.06 | 6513.25 | 0.9465 | Client 1 |  |  | 2011-05-01 00:00:00 | 27588.96 | 54096 |  |  |  | 2011-05-01 00:00:00 | 6762 | 0.9091
2012-02-01 00:00:00 | 50923 | 25970.73 | 6365.375 | 0.9658 | Client 1 |  |  | 2011-06-01 00:00:00 | 25532.13 | 50063 |  |  |  | 2011-06-01 00:00:00 | 6257.875 | 0.9305
2012-03-01 00:00:00 | 52062 | 26551.62 | 6507.75 | 0.976 | Client 1 |  |  | 2011-07-01 00:00:00 | 31190.58 | 61158 |  |  |  | 2011-07-01 00:00:00 | 7644.75 | 0.9073
2012-04-01 00:00:00 | 58952 | 30065.52 | 7369 | 0.9788 | Client 1 |  |  | 2011-08-01 00:00:00 | 33484.56 | 65656 |  |  |  | 2011-08-01 00:00:00 | 8207 | 0.9377
2012-05-01 00:00:00 | 51546 | 26288.46 | 6443.25 | 0.9677 | Client 1 |  |  | 2011-09-01 00:00:00 | 29789.61 | 58411 |  |  |  | 2011-09-01 00:00:00 | 7301.375 | 0.9575
2012-06-01 00:00:00 | 55038 | 28069.38 | 6879.75 | 0.9775 | Client 1 |  |  | 2011-10-01 00:00:00 | 27371.7 | 53670 |  |  |  | 2011-10-01 00:00:00 | 6708.75 | 0.9713
2012-07-01 00:00:00 | 67901 | 34629.51 | 8487.625 | 0.9752 | Client 1 |  |  | 2011-11-01 00:00:00 | 35659.71 | 69921 |  |  |  | 2011-11-01 00:00:00 | 8740.125 | 0.948
2012-08-01 00:00:00 | 69657 | 35525.07 | 8707.125 | 0.9652 | Client 1 |  |  | 2011-12-01 00:00:00 | 26126.28 | 51228 |  |  |  | 2011-12-01 00:00:00 | 6403.5 | 0.9262
2012-09-01 00:00:00 | 62307 | 31776.57 | 7788.375 | 0.9764 | Client 1 |  |  | 2012-01-01 00:00:00 | 26574.06 | 52106 |  |  |  | 2012-01-01 00:00:00 | 6513.25 | 0.9465
2010-10-01 00:00:00 | 68565 | 34968.15 | 8570.625 |  | Client 2 |  |  | 2012-02-01 00:00:00 | 25970.73 | 50923 |  |  |  | 2012-02-01 00:00:00 | 6365.375 | 0.9658
2010-11-01 00:00:00 | 73297 | 37381.47 | 9162.125 |  | Client 2 |  |  | 2012-03-01 00:00:00 | 26551.62 | 52062 |  |  |  | 2012-03-01 00:00:00 | 6507.75 | 0.976
2010-12-01 00:00:00 | 56540 | 28835.4 | 7067.5 |  | Client 2 |  |  | 2012-04-01 00:00:00 | 30065.52 | 58952 |  |  |  | 2012-04-01 00:00:00 | 7369 | 0.9788
2011-01-01 00:00:00 | 69627 | 35509.77 | 8703.375 |  | Client 2 |  |  | 2012-05-01 00:00:00 | 26288.46 | 51546 |  |  |  | 2012-05-01 00:00:00 | 6443.25 | 0.9677
2011-02-01 00:00:00 | 53243 | 27153.93 | 6655.375 |  | Client 2 |  |  | 2012-06-01 00:00:00 | 28069.38 | 55038 |  |  |  | 2012-06-01 00:00:00 | 6879.75 | 0.9775
2011-03-01 00:00:00 | 61405 | 31316.55 | 7675.625 |  | Client 2 |  |  | 2012-07-01 00:00:00 | 34629.51 | 67901 |  |  |  | 2012-07-01 00:00:00 | 8487.625 | 0.9752
2011-04-01 00:00:00 | 54860 | 27978.6 | 6857.5 |  | Client 2 |  |  | 2012-08-01 00:00:00 | 35525.07 | 69657 |  |  |  | 2012-08-01 00:00:00 | 8707.125 | 0.9652
2011-05-01 00:00:00 | 69067 | 35224.17 | 8633.375 | 0.9091 | Client 2 |  |  | 2012-09-01 00:00:00 | 31776.57 | 62307 |  |  |  | 2012-09-01 00:00:00 | 7788.375 | 0.9764
2011-06-01 00:00:00 | 70846 | 36131.46 | 8855.75 | 0.9305 | Client 2 |  |  | Client 2 | 778503.2699999998 | 1526477 |  |  |  | Client 2 | 190809.625 | 23.1467
2011-07-01 00:00:00 | 56547 | 28838.97 | 7068.375 | 0.9073 | Client 2 |  |  | 2010-10-01 00:00:00 | 34968.15 | 68565 |  |  |  | 2010-10-01 00:00:00 | 8570.625 | 0.99
2011-08-01 00:00:00 | 58341 | 29753.91 | 7292.625 | 0.9377 | Client 2 |  |  | 2010-11-01 00:00:00 | 37381.47 | 73297 |  |  |  | 2010-11-01 00:00:00 | 9162.125 | 0.99
2011-09-01 00:00:00 | 68384 | 34875.84 | 8548 | 0.9575 | Client 2 |  |  | 2010-12-01 00:00:00 | 28835.4 | 56540 |  |  |  | 2010-12-01 00:00:00 | 7067.5 | 0.99
2011-10-01 00:00:00 | 72863 | 37160.13 | 9107.875 | 0.9713 | Client 2 |  |  | 2011-01-01 00:00:00 | 35509.77 | 69627 |  |  |  | 2011-01-01 00:00:00 | 8703.375 | 0.99
2011-11-01 00:00:00 | 60480 | 30844.8 | 7560 | 0.948 | Client 2 |  |  | 2011-02-01 00:00:00 | 27153.93 | 53243 |  |  |  | 2011-02-01 00:00:00 | 6655.375 | 0.99
2011-12-01 00:00:00 | 52898 | 26977.98 | 6612.25 | 0.9262 | Client 2 |  |  | 2011-03-01 00:00:00 | 31316.55 | 61405 |  |  |  | 2011-03-01 00:00:00 | 7675.625 | 0.99
2012-01-01 00:00:00 | 62231 | 31737.81 | 7778.875 | 0.9465 | Client 2 |  |  | 2011-04-01 00:00:00 | 27978.6 | 54860 |  |  |  | 2011-04-01 00:00:00 | 6857.5 | 0.99
2012-02-01 00:00:00 | 72444 | 36946.44 | 9055.5 | 0.9658 | Client 2 |  |  | 2011-05-01 00:00:00 | 35224.17 | 69067 |  |  |  | 2011-05-01 00:00:00 | 8633.375 | 0.9091
2012-03-01 00:00:00 | 56681 | 28907.31 | 7085.125 | 0.976 | Client 2 |  |  | 2011-06-01 00:00:00 | 36131.46 | 70846 |  |  |  | 2011-06-01 00:00:00 | 8855.75 | 0.9305
2012-04-01 00:00:00 | 62824 | 32040.24 | 7853 | 0.9788 | Client 2 |  |  | 2011-07-01 00:00:00 | 28838.97 | 56547 |  |  |  | 2011-07-01 00:00:00 | 7068.375 | 0.9073
2012-05-01 00:00:00 | 62275 | 31760.25 | 7784.375 | 0.9677 | Client 2 |  |  | 2011-08-01 00:00:00 | 29753.91 | 58341 |  |  |  | 2011-08-01 00:00:00 | 7292.625 | 0.9377
2012-06-01 00:00:00 | 62595 | 31923.45 | 7824.375 | 0.9775 | Client 2 |  |  | 2011-09-01 00:00:00 | 34875.84 | 68384 |  |  |  | 2011-09-01 00:00:00 | 8548 | 0.9575
2012-07-01 00:00:00 | 66536 | 33933.36 | 8317 | 0.9752 | Client 2 |  |  | 2011-10-01 00:00:00 | 37160.13 | 72863 |  |  |  | 2011-10-01 00:00:00 | 9107.875 | 0.9713
2012-08-01 00:00:00 | 72096 | 36768.96 | 9012 | 0.9652 | Client 2 |  |  | 2011-11-01 00:00:00 | 30844.8 | 60480 |  |  |  | 2011-11-01 00:00:00 | 7560 | 0.948
2012-09-01 00:00:00 | 61832 | 31534.32 | 7729 | 0.9764 | Client 2 |  |  | 2011-12-01 00:00:00 | 26977.98 | 52898 |  |  |  | 2011-12-01 00:00:00 | 6612.25 | 0.9262
 |  |  |  |  |  |  |  | 2012-01-01 00:00:00 | 31737.81 | 62231 |  |  |  | 2012-01-01 00:00:00 | 7778.875 | 0.9465
 |  |  |  |  |  |  |  | 2012-02-01 00:00:00 | 36946.44 | 72444 |  |  |  | 2012-02-01 00:00:00 | 9055.5 | 0.9658
 |  |  |  |  |  |  |  | 2012-03-01 00:00:00 | 28907.31 | 56681 |  |  |  | 2012-03-01 00:00:00 | 7085.125 | 0.976
 |  |  |  |  |  |  |  | 2012-04-01 00:00:00 | 32040.24 | 62824 |  |  |  | 2012-04-01 00:00:00 | 7853 | 0.9788
 |  |  |  |  |  |  |  | 2012-05-01 00:00:00 | 31760.25 | 62275 |  |  |  | 2012-05-01 00:00:00 | 7784.375 | 0.9677
 |  |  |  |  |  |  |  | 2012-06-01 00:00:00 | 31923.45 | 62595 |  |  |  | 2012-06-01 00:00:00 | 7824.375 | 0.9775
 |  |  |  |  |  |  |  | 2012-07-01 00:00:00 | 33933.36 | 66536 |  |  |  | 2012-07-01 00:00:00 | 8317 | 0.9752
 |  |  |  |  |  |  |  | 2012-08-01 00:00:00 | 36768.96 | 72096 |  |  |  | 2012-08-01 00:00:00 | 9012 | 0.9652
 |  |  |  |  |  |  |  | 2012-09-01 00:00:00 | 31534.32 | 61832 |  |  |  | 2012-09-01 00:00:00 | 7729 | 0.9764
 |  |  |  |  |  |  |  | Grand Total | 1506714.42 | 2954342 |  |  |  | Grand Total | 369292.75 | 46.29339999999999