Table Filtering

[BA11501Banderso]

I have a table with a long list of accounts and changes in those accounts from the prior month.  I have a second table I'd like to have show the monthly totals for the past two years for the account clicked on in the first table.  The problem I am having is when I click on the account in the first table, I'm only able to see the one month referenced in the first table in the second.  The point of the first table is to highlight outliers.  The point of the second table is to see how big of an issue it is in relation to the previous months.

[BA11501Banderso]

Thank you @Whitewater100.  It did work.  The issue that was keeping me from having the interactions work correctly is I had a date filtered.

[Whitewater100 · Accepted solution]

Hi:

This would be a nice one to do dril-through on. If you build your second detailed table with all the coulmns you want on another page, you can drop the Acct No field into this new detailed second page where it says drill-thru fields. Then when a user R-clicks your first account list at a high level they can see all the details on your drill-thru page.  Just one idea. 

To answer your question it should work. You can go to Format-Edit Interactions and choose the filtering style (or not) but normally that column should filter other visuals. Hope this gives you an option to explore.