Jump to content


Pivot Table Numerical Output


  • Please log in to reply
1 reply to this topic

#1 JPK1066


    Advanced Member

  • Members
  • PipPipPip
  • 101 posts
  • LocationHilton Head SC

Posted 28 February 2018 - 03:23 PM

I have been working with Pivot Tables generated with an OLAP database and I would like to get the output in numerical order so I can compare it in different evaluations. I'll append a sample output just to frame the request out. Can I get it in numerical order and continue working in the Pivot Table without cutting and pasting in another WS?





Attached Files

#2 Jonathan


    Forums Administrator

  • Administrators
  • 888 posts

Posted 01 March 2018 - 05:11 PM



Yes, pivot table columns can be sorted. Simply right-click on the column in the pivot table and click Sort > Sort Smallest to Largest or Sort > Sort Largest to Smallest from the shortcut menu.


You can see this done in: Expert Skills Session 8: Pivot Tables: Lesson 8-5: Apply a simple filter and sort to a pivot table.


I hope this is the answer you were looking for, but please feel free to reply if you need any more help with this.

Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users