3 Replies Latest reply on Jul 12, 2016 9:54 PM by Lance Martens

    Assistance required with how to go about “Sorting” Similar Event Counts highest to lowest

    Lance Martens

      Hi All,

       

      I would appreciate any assistance with the following “Sorting” issue I have.

       

      Logic:

      • My data is sorted highest to lowest based on “Count of delay events” of total down time
      • However, I also have an underlying SUM of delay duration factor to consider

       

      Require:

      • Keeping my delay Count hierarch the same
      • I need to then have all the “Similar Count event values” to then be “Sorted” based on highest to lowest “SUM of delay down time”

       

      With reference to my attached workbook: All similar count events, need to be sorted highest to lowest based on the sum of duration for each of the respective event count groups

       

      Any guidance will be most appreciated, 

      Cheers, 

      Lance