5 Replies Latest reply: Nov 6, 2018 5:30 PM by Juraj Misina RSS

    Sorting in a pivot table.

    Randy Krauss

      I have a pivot table consisting of several levels (rows). In the second level, I have 3 values (lets call it town, state, country).  The default seems to be alphabetical.    I see you can control the sort by expression, numerically, or alphabetically.  How can I make it so it goes country, state, town.......Is there an expression I can use to force it into an order.  TIA