8 Replies Latest reply on May 7, 2018 8:28 PM by kumar bharat

    Filter data based on multiple criteria

    Rajhesh Kumar A S A

      Hi Experts,

       

                       I need to filter the data based on multiple criteria, like same Ticket No, Same Issue Code, Same Priority but the team name should not contain the substring "Power" .

       

      Also I need to sort the output data, according to Ticket No.( i.e grouping Ticket No)

       

      Below is the sample Input

       

      Ticket NoIssue CodeTeamPriority
      TT0101ALMRAN2
      TT0102QPCTAC3
      TT0101ALMRAN2
      TT0103RECPOWER RAN3
      TT0102QPCTAC3
      TT0103RECRAN3

       

      And the output should be

         

      Ticket NoIssue CodeTeamPriority
      TT0101ALMRAN2
      TT0101ALMRAN2
      TT0102QPCTAC3
      TT0102QPCTAC3

       

      I tried to create calculation field as below, but I'm not sure how to fix the calculation field error

       

      {FIXED[Ticket No],[Issue Code],[Priority]: NOT CONTAINS([Team],'Power')}

       

      Thanks in advance, guys.... :-)