How can I show data that is not associated with selections?
I have a document with training data and it is easy to show the training that employees have taken, but I want to show all the courses, including those that have not been completed.
The data structure contains a table for employees, another for courses, and both are linked to a fact table with the session information.
Not sure if this is exactly what you're looking for but it might give you an idea to help resolve the issue.
What I've done in the attached example is create a 'dummy' record on the fact table for all employee/course combinations where the employee has not taken the course. I added a 'Course Taken' flag that can be used in charts for aggregation.
