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

    Creating a sort order

    radhika sriramoju



      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 :



      '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]))