November 16, 2019
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:
This way, the data is organized by week and by the day of that week.
Thanks in advance ,
December 20, 2019
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
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.