7 Replies Latest reply: Apr 28, 2016 1:50 AM by V SUDHAKAR RSS

    Creating a sort order

    radhika sriramoju

      Hi

       

      I have a dimension in the table with the following calculated expression, I am getting the values from 2 different columns., how do I specify the sort order for the values ?

       

      I want sort order to be as below :

       

      'Uptime',

      'Escapes / Mo'

      P0 and P1 in Production'

      'FCI Top 50'

       

      =if(match(Category,'Escapes / Mo','P0 and P1 in Production'),Category,
      if(match([User Friendly Metric Name],'Uptime','FCI Top 50'),[User Friendly Metric Name]))

       

      Thanks!