Reporting on Profile Sources/ Source Types
SummaryOBI Assistance- Profile Source Fields
I am trying to splice out my "Profile Source" field in OBI into two separate columns.
Current report: Candidate Name- candidate identifier- Address-City-State-UDF1-UDF2. Following these standard columns, I would like:
Column 1- should should the "Profile Source" associated with Profile Source Type = AA.
Column 2- would show the "Profile Source" data associated with any other Profile Source Type.
The reason I am doing this is to consolidate my report to show one row per candidate. Right now I often have two rows per candidate due to two separate profile sources. I have tried doing a Case Statement to meet this need, but either its not possible or I'm not doing it correctly.