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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,651
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,114,066
Messages
5,545,792
Members
410,707
Latest member
BarnOwl
Top