18 Replies Latest reply: Feb 9, 2017 4:41 PM by Sunny Talwar RSS

    Question re: Sorting

    Mike Sawyer

      Hi,

       

      I'm using a pivot table and have a question about sorting.  Here is a screenshot of the table, where I'm sorting by Agmnt ID, Obligation Date and Unit Location:

       

       

       

      Capture.JPG

       

      As you can see the date "6/30/2020" has two obligations, one which has been 'Fufilled' (by "Ashland"0 and one which has not (and therefore is null). 

       

      My question is, how can I get the records to sort so that "Ashland" is listed first, and the null field is listed second?

       

      I thought it would be easy to just go into the sort panel for the "unit Location" field and sort alphabetically as shown below, but it does not affect the sort sequence:

       

      Capture1.JPG

      Thanks for any help or ideas anyone can offer!