Pivot Table

I’ve created a pivot table, but  how to i get it to show all results rather than average.count. sum etc.

 

I just want the table to lists all results, for a particular person or week

 






















Workstream Date Input Interaction ID Account Number Date of Call Time of Call call Length Coach Agent Team SM Quality P&P Week Month
Type A 09-Feb-17 CON 74695130 ‘61211111111 06/02/2017 10:05:00 02:51:00 A Davies V Twiss MSheridan A Taylor 66.67 100 2016 12 December 2016
Type A 03-Feb-17 74173793 ‘61111111111 02/02/2017 12:51:00 05:37:00 N Barker V Twiss M Sheridan A Taylor 58.33 100 2016 12 December 2016
Type B 29-Jan-17 73379507 ‘62111111111 28/01/2017 12:13:00 02:14:00 N Barker S Barbour N Barker J Ryan 75 100 2017 01 January 2017
Type B 29-Jan-17 73376760 ‘22111111111 28/01/2017 12:13:00 02:34:00 N Barker S Barbour N Barker J Ryan 75 100 2017 01 January 2017
Type B 29-Jan-17 73375287 ‘621111111111 28/01/2017 12:10:00 05:20:00 N Barker M Kenny S White J Ryan 50 0 2017 02 February 2017
Type B 03-Feb-17 SBS_Con ‘63111111111 02/02/2017 00:00:00 00:00:00 S White M Kenny S White A Taylor 66.67 33.33 2017 02 February 2017

 

By: Matt

Leave a Reply

Your email address will not be published. Required fields are marked *