+ Reply to Thread
Results 1 to 3 of 3

HOw to sort two columns in pivot table

  1. 02-14-2020, 12:06 AM #1
    kobichu713
    kobichu713 is offline
    Registered User
    Join Date
    02-11-2020
    Location
    Australia
    MS-Off Ver
    excel 2016
    Posts
    19

    HOw to sort two columns in pivot table

    Hi there

    I want to sort "Sum of freight" in descending order followed by "Shipcountry". Is this possible?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-14-2020, 12:20 AM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: HOw to sort two columns in pivot table

    Hi kobichu,

    See it the attached does what you need. You can also repeat the 1st row names using options.

    Sort Pivot Table problem.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 02-14-2020, 01:27 AM #3
    kobichu713
    kobichu713 is offline
    Registered User
    Join Date
    02-11-2020
    Location
    Australia
    MS-Off Ver
    excel 2016
    Posts
    19

    Re: HOw to sort two columns in pivot table

    Hi

    I will be using vlookup to pull this data so the columns cannot be changed and must appear in this order. Anyother alternative way to sort in this particular order?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 data in several columns without using pivot table
    By KIBAAKO in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-20-2019, 06:48 AM
  2. sort a column from a conditional sort in a pivot table
    By Chente in forum Excel General
    Replies: 0
    Last Post: 02-20-2019, 10:53 AM
  3. [SOLVED] Sort pivot table by difference of two columns
    By rawbeanz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2015, 08:32 AM
  4. Need to sort a pivot table on multiple columns
    By keighty in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-14-2015, 03:14 PM
  5. How to Sort Multiple Columns in a Pivot table
    By ramki in forum Excel General
    Replies: 1
    Last Post: 08-07-2009, 11:38 PM
  6. How to sort the columns in pivot table basing on the other columns value
    By Neerja in forum Excel General
    Replies: 0
    Last Post: 12-12-2008, 12:06 AM
  7. How to sort Pivot table columns?
    By ramki in forum Excel General
    Replies: 1
    Last Post: 07-16-2008, 02:29 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1