All about pivot tables part 2: Sorting
![](https://static.wixstatic.com/media/168c91_93898751e84f41d79a4a7d46477fd42e~mv2.gif/v1/fill/w_200,h_147,al_c,pstr/168c91_93898751e84f41d79a4a7d46477fd42e~mv2.gif)
In this post, I'm going to cover how to sort a pivot table, whether it's by numerical value or alphabetical order.
Continuing from part 1 of this 4 part series, I'm going to show you how to sort the values by LARGEST TO SMALLEST. To do that:
Click on any value in the GRAND TOTAL column > Right click > Sort > Largest to Smallest. It’s not necessary to do it in this example but I'm just showing you how you'd do it.
![](https://static.wixstatic.com/media/168c91_f70245639bee49f6b1fc2143b6a9f199~mv2.png/v1/fill/w_487,h_266,al_c,q_85,enc_avif,quality_auto/168c91_f70245639bee49f6b1fc2143b6a9f199~mv2.png)
Give pivot tables a go by replicating my example here: Crime Statistics
Notes: Categorical data and images of this tutorial are based on the following:
'Pivot' GIF sourced from giphy.com
List of council areas from State Government of Victoria, Victorian Local Councils - http://www.vic.gov.au/government-economy/local-councils/victorian-local-councils.html
List of offences and offence category from Crime Statistics Agency (CSA) - https://www.crimestatistics.vic.gov.au/
All other figures and data are my own and is for illustrative purposes only.
Comments