Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!

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.