Hi @Weining Ben,

You can apply dependent dropdown into your table to filter available Departments for in dropdown menus metric.
Click this link for more detail Create a Dependent Dropdown on a Table | Community (pigment.com)

 

Hi, @Thu Mai ,
 

Thank you for your response.

As I understand it, this feature allows restricting the dropdown list options based on my Employee dimension. However, I want to restrict the dropdown list options based on the User dimension (which is in the Admin app) to display only relevant departments by users.

The issue is that the User dimension does not exist in this table, so it seems that this feature cannot be used. (Please correct me if I am wrong.)

Got you @Weining Ben

Yes you have to apply User dimension into the metric to restrict dependent dropdown for Department by User.

You said that you want to “restrict it only in this table”, maybe you can set this up, then choose Dynamic Variable - “Current User” in page options setting, so Pigment will automatically identify the current user interacting with the table

Hi @Weining Ben , have you managed to try the solution I suggest? 

There is another way, by setting up access right by Department for Specific List Properties, but this will be applied for the List Properties all over the app.
 

Hi @Thu Mai ,

Thank you for sharing the three options!
However, none of them fully meet our needs in the current situation.
Firstly, since the table does not have a User dimension, as I understand, neither Dependant Dropdown, nor Page Option can be used. Secondly, Access Rights would generally be a good choice, but as you said, it would apply to the entire app which we do not want .

So, we will choose Dependant Dropdown but will change the dependant metric from User to Employee. This will also reduce the number of departments in the dropdown list, which meets our expectations.

Thanks again for your helps.
Weining