Hi All,
First, appreciate your help.
My data table below:
| Name | task | Layer 1 | Layer 2 | Total |
| test 1 | 1.test 21 | 1 | 2 | 3 |
| test 1 | 2.test 22 | 2 | 3 | 5 |
| test 1 | 3.test 23 | 3 | 4 | 7 |
| test 1 | 4.test 24 | 4 | 5 | 9 |
| test 1 | 5.test 25 | 5 | 6 | 11 |
| test 1 | 6.test 26 | 6 | 7 | 13 |
| test 2 | 1.test 21 | 7 | 8 | 15 |
| test 2 | 2.test 22 | 8 | 9 | 17 |
| test 2 | 3.test 23 | 9 | 10 | 19 |
| test 2 | 4.test 24 | 10 | 11 | 21 |
| test 2 | 5.test 25 | 11 | 12 | 23 |
| test 2 | 6.test 26 | 12 | 13 | 25 |
How do I design a workflow that will handle the 'Layer' column if more layers are added by the user in the input data?
For example, there might be a 'Layer 3' column between 'Layer 2' and 'Total', and the sum in the 'Total' column should include the totals of 'Layer 1', 'Layer 2', 'Layer 3', and so on if more layers are added
The number in those Layer 1, 2,3 could be any numbers
| Name | task | Layer 1 | Layer 2 | Layer 3 | Total |
| test 1 | 1.test 21 | 1 | 2 | 3 | 6 |
| test 1 | 2.test 22 | 2 | 3 | 4 | 9 |
| test 1 | 3.test 23 | 3 | 4 | 5 | 12 |
| test 1 | 4.test 24 | 4 | 5 | 6 | 15 |
| test 1 | 5.test 25 | 5 | 6 | 7 | 18 |
| test 1 | 6.test 26 | 6 | 7 | 8 | 21 |
| test 2 | 1.test 21 | 7 | 8 | 9 | 24 |
| test 2 | 2.test 22 | 8 | 9 | 10 | 27 |
| test 2 | 3.test 23 | 9 | 10 | 11 | 30 |
| test 2 | 4.test 24 | 10 | 11 | 12 | 33 |
| test 2 | 5.test 25 | 11 | 12 | 13 | 36 |
| test 2 | 6.test 26 | 12 | 13 | 14 | 39 |
