Log In
Register
Home
August 24, 2018
Offline
Hi, hopefully a simple query but I've not been able to solve it myself!
I have a set of pivot tables where I want the rows to come out in a designated order, not alphabetical. I have a code* I could sort by, but would prefer not to combine it with its description to produce the list, but would like to sort by it. I know i can 'move' the fields up or down to my required order, which is fine for small tables, but tedious in large ones.
* the code is used is all my access databases for a variety of fields (organisations, departments etc) where the code is in the data table and the description in look up tables.
Is there a simple solution?
Thanks, Deirdre
Moderators
January 31, 2022
Offline
Let's say you have a column with the first three characters for each month (Jan, Feb, Mar etc.) Using these in pivot tables will put them in alphabetical order (like Apr, Aug, Dec etc.)
In PP, select the month column and on the Home tab, select Sort by Column and pick the column that contains the sorting order as indicated in the picture below.
1 Guest(s)
