Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jolivares
Specialist
Specialist

Sort Order for Pivot Table

Hi Every one

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe use a sort expression

=Min(Sa_Date)

View solution in original post

1 Reply
swuehl
MVP
MVP

Maybe use a sort expression

=Min(Sa_Date)