Problems sorting a pivot table

[bronsonelliott]

I hope someone can help.  I'm trying to sort a pivot table and it's giving me fits!!!

I'm pulling some data from a database.  Included in this data is a sort field called 'Sort'.  This field is a numeric field.

I have a pivot table using the data from this database and I want to sort the data by the 'Sort' field but I don't want to show the sort field.  So I thought I could use a n expression to do this but I'm getting some inconsistent results.

If you see in the screen shot, I've included the Sort field just to visualize what's going on.  I have the sort expression of sum(Sort) on the "Section", "Grouping" and "Metric" fields but it's still acting weird.  I've tried different combinations of using the expression on only 1 field but I still get inconsistent results.

Please help!!

[bronsonelliott]

I may have figured it out.  I tried using Max(Sort) and it seems to be working.  Not sure why so if anyone wants to chime in please do so.