Forum Discussion
rodfernandez
Helper I
Helper IDisplay Don't summarize values in matrix visual
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
Please have a look at the workspace on this link
It shows the matrix as you described it on your message
1 Reply
- themistoklis
Community Champion
Please have a look at the workspace on this link
It shows the matrix as you described it on your message