Nissepiano
New Member
- Joined
- Nov 1, 2019
- Messages
- 1
Hi everyone!
I need some help.
I have two tables (short version, see below). And I want put these together with the and want to have the total sum (from table 1) for the categories in table 2. The R and Z is the positions in a grid. So I want to sum up the weights in table 1 for every category in table 2 in new table total weights per category. I hope someone can help me, I can do it a via several tables, but it is not so nice with so many tables.
Regards
Nisspeiano
Weights
<colgroup><col span="4"><col></colgroup><tbody>
</tbody>
Categories
<colgroup><col span="4"><col></colgroup><tbody>
</tbody>
I need some help.
I have two tables (short version, see below). And I want put these together with the and want to have the total sum (from table 1) for the categories in table 2. The R and Z is the positions in a grid. So I want to sum up the weights in table 1 for every category in table 2 in new table total weights per category. I hope someone can help me, I can do it a via several tables, but it is not so nice with so many tables.
Regards
Nisspeiano
Weights
R | 393.333 | 420 | 446.667 | 473.333 |
Z | ||||
7.6 | 547 | 584 | 621 | 659 |
44.55 | 2116 | 2254 | 2401 | 2544 |
103.25 | 2116 | 2254 | 2401 | 2544 |
161.95 | 2116 | 2254 | 2401 | 2544 |
211.533 | 1458 | 1555 | 1651 | 1753 |
252 | 1458 | 1555 | 1651 | 1753 |
292.467 | 1458 | 1555 | 1651 | 1753 |
<colgroup><col span="4"><col></colgroup><tbody>
</tbody>
Categories
393.333 | 420 | 446.667 | 473.333 | |
7.6 | LLW-2a | LLW-1 | RISK | LOW RISK |
44.55 | LLW-2a | LLW-1 | RISK | LOW RISK |
103.25 | LLW-2a | LLW-1 | RISK | LOW RISK |
161.95 | LLW-2a | LLW-1 | RISK | LOW RISK |
211.533 | LLW-2b | LLW-2a | LLW-1 | LOW RISK |
252 | LLW-2b | LLW-2a | LLW-1 | RISK |
292.467 | LLW-3 | LLW-2a | LLW-1 | RISK |
<colgroup><col span="4"><col></colgroup><tbody>
</tbody>