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.