+ Reply to Thread
Results 1 to 1 of 1

Pivot table changing the order of my raw data?

  1. #1
    Registered User
    Join Date
    01-21-2014
    Location
    Florida, USA
    MS-Off Ver
    Excel 2010
    Posts
    21

    Pivot table changing the order of my raw data?

    I have a pivot table on Sheet 2, pulling from Table1 on Sheet 1. This is a QA report with questions in a certain order. The pivot table is only changing one question in the order and I can't figure out how to fix this! Any ideas?

    Order it's in on my raw data sheet:
    Greeting/Answer time requirements met
    Verification requirements met
    Proper tone was used throughout call
    Empathy and acknowledgement throughout call
    Ownership & Agenda throughout call
    Triple Check/Retention offered
    Used tools effectively
    Membership acknowledged or offered
    Refrained from making negative statements
    Appropriate hold/dead air time used - Asked permission to place on hold and thanked for holding upon return
    First Call Resolution and completed requested changes on all platforms
    Was the account documented correctly in Sag
    Did the agent go Above & Beyond to generate enthusiasm or loyalty toward company?
    Call summary/follow up/email option offered
    Call closing requirements met

    Order my pivot table sorts it:
    Refrained from making negative statements
    Greeting/Answer time requirements met
    Verification requirements met
    Proper tone was used throughout call
    Empathy and acknowledgement throughout call
    Ownership & Agenda throughout call
    Triple Check/Retention offered
    Used tools effectively
    Membership acknowledged or offered
    Appropriate hold/dead air time used - Asked permission to place on hold and thanked for holding upon return
    First Call Resolution and completed requested changes on all platforms
    Was the account documented correctly in Sag
    Did the agent go Above & Beyond to generate enthusiasm or loyalty toward company?
    Call summary/follow up/email option offered
    Call closing requirements met
    Last edited by kgowett; 07-01-2016 at 08:54 AM. Reason: Add pictures

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 03-17-2015, 04:36 AM
  2. Replies: 1
    Last Post: 08-26-2013, 07:27 AM
  3. Arrange Data on Pivot table in Ascending order
    By Excel Dumbo in forum Excel General
    Replies: 1
    Last Post: 07-19-2012, 08:53 PM
  4. 2010 Pivot Table Sorting The Same Order As Data Source
    By Nunzio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2012, 05:47 PM
  5. [SOLVED] Changing the data of a Pivot Table
    By Bonbon in forum Excel General
    Replies: 2
    Last Post: 02-20-2006, 12:40 PM
  6. Replies: 1
    Last Post: 08-04-2005, 02:05 PM
  7. Replies: 1
    Last Post: 06-03-2005, 08:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1