Hello everyone,
I have a dataset that is going through a series of calculations, but I struggle with adding the total for certain columns (determined by my user).
The easiest and most flexible way I can think of is appending the dataset to itself and adding 'Total' to fields to total.
I could hard code this by using the formula tool and union like below:
But I want to decide which fields to total by using another table.
Let's say i have the dataset below:
| fieldA | fieldB | fieldC | value |
| A | A | A | 0,21 |
| A | A | B | 0,15 |
| A | B | A | 0,31 |
| A | B | B | 0,45 |
| B | A | A | 0,55 |
| B | A | B | 0,65 |
| B | B | A | 0,41 |
| B | B | B | 0,25 |
And my user indicates that these are the two fields for which he wants the total
| fieldToTotal |
| fieldA |
| fieldB |
Basically I'd like a table that is three times as large as the original: the original table + the original table where fieldA = 'total' and the original table where fieldB = 'total'. It would look like the following:
| fieldA | fieldB | fieldC | value |
| A | A | A | 0,21 |
| A | A | B | 0,15 |
| A | B | A | 0,31 |
| A | B | B | 0,45 |
| B | A | A | 0,55 |
| B | A | B | 0,65 |
| B | B | A | 0,41 |
| B | B | B | 0,25 |
| Total | A | A | 0,21 |
| Total | A | B | 0,15 |
| Total | B | A | 0,31 |
| Total | B | B | 0,45 |
| Total | A | A | 0,55 |
| Total | A | B | 0,65 |
| Total | B | A | 0,41 |
| Total | B | B | 0,25 |
| A | Total | A | 0,21 |
| A | Total | B | 0,15 |
| A | Total | A | 0,31 |
| A | Total | B | 0,45 |
| B | Total | A | 0,55 |
| B | Total | B | 0,65 |
| B | Total | A | 0,41 |
| B | Total | B | 0,25 |
Does anyone have an idea how to proceed?
Thanks a bunch!
Mikis
Solved! Go to Solution.
Attaching sample dynamic workflow for your case assuming that there will be only two input fields from your user.
Hi Mikis,
Here is the dynamic workflow you are looking for!
