How to select one line in a grid and refresh another grid

Options
abinchen
abinchen Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi, we have a dashboard which contains 2 grids. The first grid is applied to a list. The second grid is showing items based on the selection of the first grid and applied to another list.

We need to select one line in the first grid, and let the dashboard auto-refresh the second grid based on what selection the user makes. However we cannot find a function which refers to the current selection.

I wonder if this feature can be achieved, or if there is any workarounds. Thank you.

Tagged:

Comments

  • abinchen
    abinchen Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    Please review the sample screenshot with sample data.

    1. Due to the limitation of hierarchy lists, we use a flat list in the 1st grid.

    2. The 2nd grid is applied to HR list, different from the 1st grid.

    The function we need is, when user selects a line in 1st grid, the 2nd grid will list all subordinates of the selected SalesOrgLeader.

     

  • abinchen
    abinchen Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    Thank you, @LipChean_Soh  I know smart filters and are using them somewhere else. The drawback of smart filters are that user have to input the filter value in another box and click a button to refresh dashboard. If this is the only option for this case, I will use it.

    If Anaplan can later provide a function to dynamically refer to the current selected list item, it will be great.

Categories