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

    Sorting text fields in a pivot table



      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?