Is their a way to create a table that consolidate and sum the data from two other tables? We'd like to be able to visualize it in dashboard.
Per exemple, my two initials tables would be:
Table 1
| name1 | quantity |
| Alex | 2 |
| Julia | 4 |
| Sylvie | 6 |
Table2
| name2 | quantity |
| Julia | 4 |
| Alex | 3 |
| Tom | 2 |
And the result after consolidation would be:
| name | quantity |
| Alex | 5 |
| Julia | 8 |
| Sylvie | 6 |
| Tom | 2 |
So far, I'm just able to create the initials tables by using name1 as category field in table 1 and using name2 as category field in table 2 while using a count fonction for the second column in both tables.
Thank you for your help!
