+ Reply to Thread
Results 1 to 4 of 4

Can't sort a pivot table

  1. #1
    Registered User
    Join Date
    08-07-2023
    Location
    Australia
    MS-Off Ver
    10
    Posts
    2

    Can't sort a pivot table

    Hi Brains Trust

    I'm attempting to sort a pivot table using a numerical column but having no luck. The custom sort option isn't available when I select the table or when I select the data I want to sort by.

    Not even sure where to start - I'm stumped!

    Any help appreciated.

    KC

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Can't sort a pivot table

    Welcome to the Forum KcKc0134!

    It's not possible to help with this kind of question without the file. Please see yellow banner at the top of the page and attach a sample file, disguising or removing any private data (real names, addresses, phone numbers, account numbers, email addresses, or anything that can be used to identify a person).
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    08-07-2023
    Location
    Australia
    MS-Off Ver
    10
    Posts
    2

    Re: Can't sort a pivot table

    Thank you for responding. I thought I had attached but clearly not! Please see attached now.

    Thanks again
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Can't sort a pivot table

    To see the rows sorted in descending order by AOR points, switch the order of the Horse and Rider fields in the Rows area.
    Note that in the file attached to post #3 Sheet1 was protected which makes it hard to work with.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Sort Order of Pivot Table and Vertical Axis of Pivot Chart are not the Same
    By TINHAMMER in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-30-2023, 02:45 PM
  2. How to sort Pivot Table like a TOC (Table of Contents)
    By Noizivision in forum Excel General
    Replies: 2
    Last Post: 08-20-2021, 11:29 AM
  3. Table and Pivot Table does not auto sort
    By rogrand in forum Excel General
    Replies: 1
    Last Post: 01-01-2020, 05:37 PM
  4. Replies: 0
    Last Post: 02-20-2019, 10:53 AM
  5. Sort table with only formulas...and not pivot table
    By agweyre in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2012, 09:19 PM
  6. Replies: 2
    Last Post: 05-19-2010, 05:14 AM
  7. [SOLVED] pivot table sort entries that don't yet appear in table
    By rachael in forum Excel General
    Replies: 11
    Last Post: 09-19-2005, 07:05 PM

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