Hello 🙂
I have 2 tables
| Id | zone | Amount |
| 1 | North | 10 |
| 2 | South | 15 |
| 3 | North | 5 |
| 4 | South | 6 |
| 5 | North | 4 |
| 6 | North | 12 |
| 7 | South | 15 |
| 8 | North | 3 |
| 9 | South | 9 |
| 10 | North | 11 |
| 11 | South | 15 |
| 12 | South | 4 |
| 13 | North | 2 |
| 14 | South | 12 |
| 15 | South | 4 |
| 16 | North | 14 |
| 17 | South | 10 |
| 18 | South | 4 |
| 19 | North | 13 |
| 20 | South | 3 |
| Zone | Goal |
| North | 100 |
| South | 110 |
And I need to create this Visualization Matrix
| | South | North | Total |
| Goal | 110 | 100 | 210 |
| Amount | 97 | 74 | 171 |
Compliance | 88% | 74% | 81% |
Where Amount is the sum from the amount form the first table for each zone
Goal is just the value from the second table without any operation (I am having trouble doing this part).
The last row is just the % for each zone (Amount.South/Goal.South and the same for the North).
I am having trouble showing just the value in the first row without any operation, maybe I’m not relating the 2 tables in a good way....
Thanks
