Click in one row in table and go to another table to see the details.

[rickferreiran]

Hello I have two tables Table A :
id    date  status   n_sales
1                             4
2                             6

T have table B
id           sales_details

1                    A

1                   B 

1                   C

1                   D

2                   A

2                   B

2                   C

2                  D

2                  E

2                  F

I want when I click in table A in n_sales

to go to another page and see the sales detais for that id

Is any way to do that using drill trough?

[Bibiano_Geraldo]

Hi @rickferreiran ,

Yes, it’s possible to achieve this functionality using Drillthrough. Follow these steps:

1- Make sure that you have a page for Table A:

And other page for Table B:

2- On Page of Table B, on format pane>page information, enable Drillthrough, and Drag the Id column to "Drill Through from" field, and make sure to drill through when id is used as category, and if keep all filters is enabled, please see bellow examples:

3- Now go back to page where you have Table A, right click on top of id that you want to analyse, and drill through to page where's Table B:

For this Example I drilled on id 2 and this was my result:

This is not a direct click as you asked but its the nearest one, unfortunately the direct click by default is to highlight and filter other visuals.

[Jai-Rathinavel · Accepted solution]

@rickferreiran Follow the below steps

1. Make sure you have established the relationship between Table A and Table B like below

2. In Page 1 Create a Table visual by getting the fields from Table A

3. Now go to Page 2 and create a table visual using fields from Table B and In the Drill Through Field  below drag the ID from Table A

4. Now go back to Page 1 and select a row to drill -> Select Page 2

Result:

Did I answer your question? If yes, please mark my post as a solution. 

Thanks,

Jai