Display Don't summarize values in matrix visual

[rodfernandez]

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

[themistoklis · Accepted solution]

@rodfernandez

Please have a look at the workspace on this link

It shows the matrix as you described it on your message