Log In
Register
Home
November 16, 2019
Offline
Hello,
Is there any way to organize the data in a pivot table when the data is not in alphabetical order or numbers ?
In the example I attach I have the data in the table organized by Week_Day such as "W.29_L" where the letter "L" is "lunes (Monday). It seems that when I create the pivot table, the data is organized in alphabetical order but this is not the order I wish, it should be:
W. 29_L
W. 29_M
W. 29_X
W.29_J
W.29_V
This way, the data is organized by week and by the day of that week.
Thanks in advance 
,
Cristina
Trusted Members
December 20, 2019
Offline
Adding a workbook example is always better than adding a screen dump as we have to recreate data to doing any testing
as far as know you only have logical sorting in pivot tables such alphabetical, numerical or days etc.
i cant see the data due to the screen dump but i am guessing that w.29_V is text? if you want to sort these in a logical order you will need to split the data in to 2 columns and then pivot (or extra columns if you want to keep the format above and then hide the column in the pivot table
July 16, 2010
Offline
Hi Cristina,
This post covers sorting options in PivotTables.
If you have a lot of items to sort then these options may not be ideal. In which case you can use Power Pivot (available in these versions of Excel) and add a numeric column that specifies the sort order which you can use to apply the 'Sort by column' rule in the data model.
I hope that points you in the right direction. If you get stuck, please come back and like Purfleet said, attach a sample Excel file so we can give you an accurate answer.
Mynda
1 Guest(s)
