Analytic using multiple tables

Hey @ChirristopherOficial -

Have you seen this post Using Values In One Single Select Menu to Dynamically Populate Values in a Second Single Select Menu (Part 1) / is this what you are looking to achieve?