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:
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.
