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:
| Model | Role | Specialization |
| APJ | Role-1 | ABC |
| EMEA | Role-1 | ABC |
| APJ | Role-2 | XYZ |
| EMAR | Role-2 | XYZ |
| US | Role-2 | XYZ |
| US | Role-3 | MNO |
| APJ | Role-4 | PQR |
| EMAR | Role-4 | PQR |
| US | Role-4 | EFG |
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)
| Role | Specialization | APJ | EMEA | US |
| Role-1 | ABC | Yes | Yes | No |
| Role-2 | XYZ | Yes | Yes | Yes |
| Role-3 | MNO | No | No | Yes |
Report-2:
(Hints: this is the data which is having different specializations for the same role)
| Model | Role | Specialization |
| APJ | Role-4 | PQR |
| EMAR | Role-4 | PQR |
| US | Role-4 | EFG |
.>
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
