+ Reply to Thread
Results 1 to 3 of 3

HOw to sort two columns in pivot table

  1. #1
    Registered User
    Join Date
    02-11-2020
    Location
    Australia
    MS-Off Ver
    excel 2016
    Posts
    12

    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

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    14,472

    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 * below to say thanks.

  3. #3
    Registered User
    Join Date
    02-11-2020
    Location
    Australia
    MS-Off Ver
    excel 2016
    Posts
    12

    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 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