Find occurrences of a Dimension code without hierarchy
I'm stuck on something. I have a Job dimension that has Job code and Job name. (100 - Tech I)
That Job flat list is not in a hierarchy.
But I've created another list called JobL5 that has the Department as a Parent. Each dept will have several jobs listed underneath. And the same job can be in several depts.
I want to create a dashboard where I can click on the Job code and have another grid show me all the different depts that have that job.