Switch table and filter

[louise119]

I have a filter and a table A and a table B.
I am implementing a Switch dropdown to switch the table to A or B. 

Table A and Table B are quoted from different DB tables.

・Filter condition: Table X in DB
・Table A: Table A in DB
・Table B: Table B in DB

Although they are related, Table A and Table B contain RowNo() as RowIDA and RowNo() as RowIDB to count the number of rows respectively, so Table A and Table B cannot be put in the same table. 

Therefore, even if you narrow down the conditions with a filter, you can only narrow down the table A, and there is no table B.

Is there a better way?

[Michael_Tarallo]

Hello Louise

If this is working for you - then I would say that it is ok for your use case. If you would like to explain a bit more of why you are doing this, it may be helpful to discover if a better way does exist.

Are you familiar with alternate states?

As you can setup individual charts and filters to link to one another without effecting one another.

Take a look at this and let me know if this helps: https://youtu.be/IKnd1wgNPnc 

[louise119]

Thank you so much! I could make it!

But, I use the if statement on filter, so  I can't transfer the data from sheet to sheet.
How should I transfer data from sheet to sheet?