Forum Discussion
Having multiple active relationships
Hello
I have two tables with the same column names, but the first (Staff Timelines) is filled in with the Actual hours and costs per period, per discipline, per phase, per staff name, and the second (Budget timelines) is filled in with the budgeted hours and costs with the same details.
I have 5 filters - task description, phase, discipline, period, staff name that can be applied to both tables, and I want all of them to work simultaneously.
Sadly I can have only one active relationship between the two tables so only One filter can work.
Is there a way to have all 5 filters working simultaneously for both tables ?
2 Replies
There are a few way to do it. You could combine the tables together into one, adding in an extra column which says whether it's actual or budget. Then you'd need to filter visuals and measures to be one or the other.
You could also create separate dimension tables, one for each filter. This way you can link each dimension to both the actual and budget table and filter both at the same time.
Thank you very much, it worked!
I currently have a graph that is showing me the monthly hours/costs, but I would like to make a graph that shows the accumulated monthly hours/costs and comparing the actual vs the budget...
Could you please assist me in finding the correct Calculation I have to make ?
Many thanks in advance!
