3 Replies Latest reply: Jan 29, 2015 6:46 AM by Melissa van Kluyve RSS

    Sorting text fields in a pivot table

      Hello,

       

      I have a table with Volume Segmentation (A,B,C,D) plotted against RRS Segmentation (Runner, Repeater, Stranger).

       

       

      When it comes to sorting my table, I can't seem to get Runner, Repeater, Stranger in the right order. The load order for this field would achieve this, but this option is greyed out.

       

      I added a table counting the rows for unique Runner / Repeater / Stranger values, then tried to sort by RRSRow descending, also not working:

       

       

      Any thoughts? Is there a way to sort on a text field that is not A>Z, or name the values in the text field explicitly?

       

      Thanks

      Mel