+ Reply to Thread
Results 1 to 15 of 15

Sorting pivot table data

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    Angry Sorting pivot table data

    Can someone tell me how I sort this table using the total column and in descending value?
    Thank you, it's driving me crazy.
    Pivot Table001.jpg

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

    Re: Sorting pivot table data

    clikc on column Total

    choose sort => decending
    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
    Registered User
    Join Date
    01-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Sorting pivot table data

    If I selectt just the total column I get this:
    Pivot Table003.jpg
    If I select the whole table the sort option goes away.

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

    Re: Sorting pivot table data

    You have to click in the column Total

    Not select column E (in your example).

  5. #5
    Registered User
    Join Date
    01-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Sorting pivot table data

    Hmm. I did that, the sheet flickers like it does when it sorts and then nothing has moved.
    I'm very challenged with this Excel thing, thank you for helping.

  6. #6
    Registered User
    Join Date
    01-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Sorting pivot table data

    I need it to look like this:
    Pivot Table004.jpg

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

    Re: Sorting pivot table data

    Post your file (of course, without confidentional information), so we can work in it.

  8. #8
    Registered User
    Join Date
    01-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Sorting pivot table data

    It's 12 megs
    I tried 7zip but gives me an error when I upload.
    Can I email it somewhere?

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

    Re: Sorting pivot table data

    just a small example (with the same format) will do.

    just post it on this forum (not mail).

  10. #10
    Registered User
    Join Date
    01-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Sorting pivot table data

    The smallest I can get it is 6 mg. and that like 15 rows of data.I must be doing something wrong.
    I will keep trying.
    Thank you for your help and patience.
    kellie

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

    Re: Sorting pivot table data

    Paste just 15 row in another workbook and make an pivot table of that.

  12. #12
    Registered User
    Join Date
    01-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Sorting pivot table data

    I hope this is enough.
    Attached Files Attached Files

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

    Re: Sorting pivot table data

    Excel 2007 =>

    I used options for pivot table (at the end of the lint).

    then i used sort A-Z or Z-A (count of column 10).

    doing that i'm in column E (in the table).

    Then I get the result as shown in the attached file.
    Attached Files Attached Files

  14. #14
    Registered User
    Join Date
    01-14-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Sorting pivot table data

    Okay I finally got it! Geez am I blonde or what?! (in fact I am! Ha!)
    Thank you for helping me.
    Kellie

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

    Re: Sorting pivot table data

    Thanks for the reply.

    Glad I could help you.

    That's why i asked for an workbook with data.

    So I can show you.

    If your question is solved, will you mark it as solved?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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