Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Sorting on Pivot Table

    I have a Piviot table with names and have inserted calculated items. I now wish to sort the pivot table by name and Ascending order folows by Comm in asceding order

    See attached sample. It would be appreciated if someone could assist me
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Have you tried a custom sort? Unfortunaltely we have moved to 2010 and it is slightly different. It says to drag the item, but I haven't been able to figure out how to drag it.

    In 2003 I used custom sort all the time. You can select whatever order you want, just move the names up and down to sut.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    I am also on 2010 and am battling to figure out how to drag the items under sort

    I will post a query regarding this

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    RIght click the "sales Manager" header in the pivot table, sort, more sort options, make sure "manual" is checked, ok

    Select a name in the pivot table, move the mouse until the cursor is the "4-arrows" indicating that it can be moved, then drag it where desired, repeat as needed

    Steve

  5. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Sorting on Pivot Table

    Hi Steve

    Thanks for the help

    Regards

    Howard

Posting Permissions

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