HI
We are having an issue in HR reporting and how to report this scenario.
If we know that all employees have two characteristics associated with their record, we are trying to report training hours using both characteristics -
Characteristic 1 has - professional, executive and so forth and the Characteristic2 has RN, Pharmacist, etc. My report needs to display:
Training hours
Professional (01) XX
Executive (03) XX
RNs (AAA) XX (all RNs are professional (01) but not all professionals are RNs (AAA)
How do we display both professionals and RNs in one hierarchy? If we create a hierarchy on characteristic 1 with the professional and executive, we are unable to also display characteristic 2 values like RNs, Pharmacists etc.
Any suggestions for a solution?
Thanks
Kim