Forum Discussion
Combining Totals from 2 different tables
do you create relationships between tables?
Hi ryan_mayu ,
Yes I did. (Step 4)
I am thinking, I think I am able to create the calculation I need.
Though it is a different approach, your sample gave me an idea to do it.
Here is my thought:
1. Clean the 2 soruce table, remove un needed columns from actual and target
2. Make the names of common columns identical for both table
3. Append the 2 tables. This will just add another column which is not present on the other table.
4. Create a computation matrix on the fields dividing the 2 concerned columns
5. Arrange the columns in the matrix as usual.
Feel free to comment if you have a better suggestion or the procedure I did have a consequence.
Thank you so much for your help and time!
Your sample help me so much!