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.
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)
(Hints: this is the data which is having different specializations for the same role)
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.