Having problem with sorting in a pivottable, i am choosing sort by load order (origin) but it still having the column sorted in ascending numeriv value see picture below. the data is not loaded in this way, any suggestions?
unfortenaly i am not able to share the aplication, the data is not loaded in numeric order so i wonder why i cant sort it the way it is loaded from the excel file? in the example picture above it should be ordered 31, 21, 29 i.e. the way it is loaded.