6 Replies Latest reply on Jul 1, 2016 5:13 AM by Carl Slifer

    Sorting challenage

    Lee Forst

      Sorry for the discussion title as I'm not sure how to even ask this.   Below is a screen shot to help illustrate my question.  Right now this is sorted based on the number of records for the store.  And the individual cells (Order Numbers) are colored by the days open.  My goal is to keep this sorted as shown, but then sort the individual orders for least number of days open to greatest.  In order words, the for Store 2, the cells would go from light tan to dark brown.  I've looked at several examples of building a calculated field to be used as the sort on Store by trying to use the number of records and the Days Open, but I'm just not arriving at an answer.  Attached is the example.

       

      Capture.PNG