I have 2 Crosstabs containing 2 different data sources in Lumira Designer. Both crosstabs have the common dimension as ( ID ). Crosstab_1 has purchasing information based on the ID and Crosstab_2 has more details level information based on the same ID.
I am trying to achieve, if I click on particular ID in the column in Crosstab_1, another crosstab_2 reflects the information only for the selected particular ID in Crossstab_1.
Could anyone help how can I script both the crosstabs so that the both crosstabs interact each other on selection?
Thanks in advance!