Yesterday I was looking an application that I worked about a couple of years ago, finding an error in a pivot table ordering. See in the file attached.
I already solve the problem making a week ordering field, but I interested to know how make an expression that sort correctly the table.
By any chance another solution I find is ordering the week by frequency, as the last week of a year, that is the beginning week of the next is cut off by the end, it always have less day than the other, so it works.
