I have a pivot table with
Rows label: A, B, C, D, E, unknown1, unknown2, unknown3, etc..
It is sorted in order automatically. In my sum Values, column labels, I have some numerical data, i.e. 0, 4000, 6000, 23432, 2, 8, etc. Is it possible to sort by the column values? (so that my Rows labels change to A D, E, B,C, etc....
yes-using 'more options' in the field sorting
Josie
if at first you don't succeed try doing it the way your wife told you to
can you be more specific? i am using excel 2007 and can't find what you're talking about. thanks in advance!
right-click one of the row field values, choose Sort, More Sort Options, then choose to sort by your data field
Thanks, I almost got it. It seems like only a couple of columns are sorted correctly. I've attached a sample file of what I'm trying to do. The pivot table is included. Essentially, I have 5 columns of data, but only 2 of them got sorted properly. I'm not sure what's going on. Thanks!!
pivot_example.xlsm
the sort is performed based on the grand total of the data field not each column in turn-since they could conflict
so I shouldn't use the pivot table for this particular table that I want?
not if you require that sorting-you can only have one sort column and I can't see a way to make that give you what you need
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks