7 Replies Latest reply: Mar 23, 2018 1:01 PM by Sofia Vaz RSS

    Sort by expression Issue

    Sofia Vaz

      Hi  all,

       

      In a pivot table, I wanted to sort InventoryType in this orders:'LATE ORDER','OK ORDER','FUTURE ORDER','CLOSED ORDER','NOT CLIENT','UNIT REJECTED',null()

       

      For that I'm using this expression

       

      Match(InventoryType,'LATE ORDER','OK ORDER','FUTURE ORDER','CLOSED ORDER','NOT CLIENT','UNIT REJECTED',null())

       

      But, as you can see in the image attached, the line for null Inventory Type is the first one and not the last one. I've tried other things like

       

      Match(InventoryType,'LATE ORDER','OK ORDER','FUTURE ORDER','CLOSED ORDER','NOT CLIENT','UNIT REJECTED','')

      or

      Match(InventoryType,'LATE ORDER','OK ORDER','FUTURE ORDER','CLOSED ORDER','NOT CLIENT','UNIT REJECTED','-')

       

      But anything works…

       

      Does anyone know what i might be doing wrong?

       

      Thank you!