I have two differents tables and I want to know if is possible to create a connection between them? For example: when I clickin some value of the first pivot table, the second one does like a drill down showing other information based on the value that was clicked.
This can be done with the use of actions.
There are two ways to do this.
- The first way is with Filter action. To do this, click on Actions.
Then click on Configure new action. Name it. Select the activation method.
Then select Filter action for the Action type.
Under the Filter scope, select the fields you want to filter down to if you click on a particular row in the table.
Finally, select the Target visuals that you want to change.
- The second way is to create an action but change the action type to be Navigation action. This will change a parameter. You can then describe what sheet it goes to (it can be on the same sheet).
To make the other table filter to this value, add a filter to that table and set the filter to have the field be equal to the parameter.
Please see the QuickSight documentation for more information.
Let me know if that answers your question