I have set up a table with a few metrics in with either of the following two setups:
1) Dimensioned by Company and Department
2) Dimensions by Employee
The employee dimension has properties using the Company and Department dimensions.
In my table i can either add the direct Company and Department dimensions to my pages or the mapped versions from Employee.
However, if I select the direct dimensions in the Pages, the Employee metric (2) doesn’t filter properly. And the same happens to metric (1) dimensioned by company and department if I select the mapped dimensions in the pages.
How can i get it so that my table filters both properly?
Solved
How to sync Dimensions in the Page section of a table
- Author
Best answer by Min Li
In your case, I think you may need to add company and Department dimensions in your metric 2 through the employee properties so that each metric has company and department dimensions.
+13- Master Helper
- Answer
In your case, I think you may need to add company and Department dimensions in your metric 2 through the employee properties so that each metric has company and department dimensions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.