Sorting Pivot Table By Column In Classic Display Mode

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
665
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
Morning ,

I have a pivot table that i wish to sort by column (R) "Grand Total" , however all my attempts are just keeping the same
data in place and nor sorting as - large to small .
My pivot table is designed in the classic display , would be appreciated.

Russ
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,646
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
The sort will only happen within whatever row fields you have established. It would help to see what your PT looks like.
 

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
665
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
Hi Rory ,

Thanks for taking the time to view my post , appreciate it.

Unfortunately the data is business sensitive , i am sure you understand . I thought of a "work around " , by copying
the data as values only , and then performing a normal sorting routine . It works ... in short term ... as it is sales generated
piece of data i think i will have to attack the problem , maybe form a different angle :cool:

Thanks again , have a good weekend ,

Russ.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,825
Messages
5,544,545
Members
410,619
Latest member
gregor222
Top