+ Reply to Thread
Results 1 to 5 of 5

Sorting Pivot Table Data

  1. #1
    Registered User
    Join Date
    05-26-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    29

    Sorting Pivot Table Data

    I am trying to get my pivot table to sort by a data column. I want it to sort so the highest number is at the top, but no matter what I do, it always sorts by the first Row column.

    Is there a way to sort it by the data column? I've tried a custom sort and a normal sort.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,952

    Re: Sorting Pivot Table Data

    Click a value in the data column, after that choose for sort.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,173

    Re: Sorting Pivot Table Data

    Have you tried click on any data in the column you want to sort by then click sort?

  4. #4
    Registered User
    Join Date
    05-26-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    29

    Re: Sorting Pivot Table Data

    Thank you both, but yes. I have tried to click on different columns in the data field. I was able to get it to sort by right-clicking in the first column of the rows section, selecting sort and then more sort options. From here I was able to sort by the data field that I wanted to sort by.

  5. #5
    Registered User
    Join Date
    09-26-2014
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    63

    Re: Sorting Pivot Table Data

    After you click the sorting filter choose more sort options and try sorting Z-A by whatever the value you want it to sort by. Then click more options and click sort by and click the first cell that has the value you want to sort by and that should do it.

+ 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. Sorting Pivot Table Data
    By luckyali in forum Excel General
    Replies: 2
    Last Post: 04-29-2014, 08:34 AM
  2. Sorting Data for use by Pivot Table
    By BozzA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2014, 10:37 PM
  3. Data Sorting/Pivot Table
    By shshsh in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-09-2013, 12:41 PM
  4. Sorting pivot table data
    By KellieB123 in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 01-15-2013, 08:23 AM
  5. [SOLVED] Sorting Data in a Pivot Table
    By Janet BN in forum Excel General
    Replies: 5
    Last Post: 06-26-2006, 10:25 PM

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