0 Replies Latest reply: May 19, 2015 9:58 AM by Ravi Kumar RSS

    Need Help on Pivot/Straight table for the below Requirement

      Hi All,

       

      I have Source data, based on that I wanna split that data into two report i.e., Report-1, Report-2 as show below.

       

      Please post the answer as soon as possible.

       

      Source-Data:   

      ModelRoleSpecialization
      APJRole-1ABC
      EMEARole-1ABC
      APJRole-2XYZ
      EMARRole-2XYZ
      USRole-2XYZ
      USRole-3MNO
      APJRole-4PQR
      EMARRole-4PQR
      USRole-4EFG

       

       

      Report-1; (Hints: Split data based on Role. here for each Region Specialization will be same. here for Role-4 specializations are not same, if this is the case we have to skip that role.

       

      Simply to say: here we are displaying data in the report for each role which is having same specialization)

         

      RoleSpecializationAPJEMEAUS
      Role-1ABCYesYesNo
      Role-2XYZYesYesYes
      Role-3MNONoNoYes

       

      Report-2:

      (Hints: this is the data which is having different specializations for the same role)

         

      ModelRoleSpecialization
      APJRole-4PQR
      EMARRole-4PQR
      USRole-4EFG

       

      .>

       

      Can any one let me know the logic, and if possible attach the solution.qvw.

       

      Note: "Source-Data" sheet contains the Source data for this requirement as attached.

       

       

      Thanks,

      Ravi