Forum Discussion
Create slicer for Hierarchy across multiple tables
Actually answer from amitchandak gave me good hint and I found a solution
What I did:
1. I created new table that grab only unique values for Organisational structure
2. In all tables I created columns with aggregated values as amitchandak suggested (Key = [Department] & "-" & [Unit])
3. I created one-to-many relations for all tables with newly created table using "aggregated" field
After I plan to use not aggregated values in Slicer, that will give me hierarchy, but will filter all tables
Actually answer from amitchandak gave me good hint and I found a solution
What I did:
1. I created new table that grab only unique values for Organisational structure
2. In all tables I created columns with aggregated values as amitchandak suggested (Key = [Department] & "-" & [Unit])
3. I created one-to-many relations for all tables with newly created table using "aggregated" field
After I plan to use not aggregated values in Slicer, that will give me hierarchy, but will filter all tables