below is sample of how the data is getting populated and all we need to show all in the same portal.
project 1 - DB11 has a clickable action filter that takes it to DB12...
same with project 2 and 3, all we need is the final template..
after we merge project 1/2/3 and click on let's say project 1 - DB12 it's actionable filter go from DB12 to DB22.
Is there anyway you can share a workbook with some anonymyzed data? It is much easier to review and assist with filter actions in a .twbx file than it is to just attempt to verbally explain a set up.
Hope this helps!