0 Replies Latest reply on Sep 26, 2018 12:00 AM by meher.allamsetty

    To show the values as per the flags.

    meher.allamsetty

      Consider we have the requirement like below.

      My requirement is to find show the date,group,customer name,customer rank,experience/fresher in the report where the group should contain freshers (like group 3) and combination of fresher and experience (like group 1).It should eliminate the group with all experienced people(like group 2).Kindly help me to build the logic

       

                                                                                                                                                                    

      DateGroupCustomer NameCustomer RankExperience/Fresher
      1-Jan-181AAA1F
      BBB2E
      CCC1E
      DDD1F
      EEE1F
      1-Jan-182AAAB1E
      BBBC2E
      CCCD3E
      DDDE1E
      EEEF1E
      1-Jan-183AAAB1F
      BBBC2F
      CCCD3F
      DDDE1F
      EEEF1F

      @@

      Header 1Header 2Header 3Header 4Header 5Header 6

                                                                                                                                                                    

      DateGroupCustomer NameCustomer RankExperience/Fresher
      1-Jan-181AAA1F
      BBB2E
      CCC1E
      DDD1F
      EEE1F
      1-Jan-182AAAB1E
      BBBC2E
      CCCD3E
      DDDE1E
      EEEF1E
      1-Jan-183AAAB1E
      BBBC2E
      CCCD3E
      DDDE1E
      EEEF1E