How to link text box and show data based on certain selection
I got a requirement to develope a helpdesk dashboard. One of requirement for the dashboard is to link text box and show the data based on filter in table. I've been looking for the solution but still can't get it.
Example as per below:
If I click on view details text, then the detail list of high priority data will be display in table in other sheet.
Did you know how to do this? Could you please share with me the demo app because i don't have credential to download it.
I've created the text object with font style-underline and for the action I used the 'active sheet' and 'active object' but still can get the selected value which is 'high priority' in the table in selected sheet. The data also included the 'medium priority and low priority ' value. So, how can I get the selected value in table?
In demo app, it is they use different sheet for each different kpi and then set the table to the selected value? Because I can't even figure it out how they do the dashboard.