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...
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!
