How to show a table when filtering another table
Posted: Fri Aug 13, 2021 3:01 pm
Hi,
I need to build a Dashboard with 2 tables: table 1 and table 2, as shown in the picture attached.
Table 1 shows information corresponding to different IDItems.
Table 2 shows a drill down of each IDitem, where each IDitem has several IDsubitems.
I have currently built this dashboard and when I click on any IDitem of Table 1 to filter this table, it also filters table 2 and shows only those IDsubitems that correspond to that IDitem.
My question is: is there any possibility to hide table 2 until I click on an IDitem of table1? I mean, if table 1 is filtered when I click on on IDItem, table 2 appears (filtered accordingly by the same IDitem). If table 1 is not filered, Table 2 does not appear.
Please note that I need table 2 to appear in the same page of table 1 (this is why opening another page to show table 2 is not an option in this case)
Thanks
I need to build a Dashboard with 2 tables: table 1 and table 2, as shown in the picture attached.
Table 1 shows information corresponding to different IDItems.
Table 2 shows a drill down of each IDitem, where each IDitem has several IDsubitems.
I have currently built this dashboard and when I click on any IDitem of Table 1 to filter this table, it also filters table 2 and shows only those IDsubitems that correspond to that IDitem.
My question is: is there any possibility to hide table 2 until I click on an IDitem of table1? I mean, if table 1 is filtered when I click on on IDItem, table 2 appears (filtered accordingly by the same IDitem). If table 1 is not filered, Table 2 does not appear.
Please note that I need table 2 to appear in the same page of table 1 (this is why opening another page to show table 2 is not an option in this case)
Thanks