OTBI Pivot Table with multiple Subject Areas
Summary: I am looking to create a Pivot Table with multiple subject areas that shows the completion status of certain learning items and the existence (Yes or No) of a few document types in the Document Record.
These are the Subject Areas I am using:
- Workforce Learning - Learning Management Real Time
- Workforce Management - Documents of Record Real Time
Content (required): I can create a separate pivot table with learning item names as Columns and a separate pivot table with Document Types, but I am not able to put them on one pivot table. I would like to list the employee name and number as rows and then the learning items and document types as columns (see Desired Output on the attached). Any help would be greatly appreciated.