Hello,
I am trying to format a table in Alteryx to get it into a similar format that the pivot table function in excel uses. The input data is in a format such as this below...
| Manager | Employee | Count |
Tom | Lucia | 235 |
| Tom | Alice | 357 |
| Tom | Chris | 214 |
| David | Sauruv | 333 |
| David | Rahul | 111 |
| Alicia | Rohit | 2222 |
| Alicia | Anish | 123 |
| Ronald | Samarth | 345 |
I would like the format of the table to be as the following...
| Employee | Count |
| Tom | 806 (Calculated by adding below three values of 235 + 357 + 214) |
| Lucia | 235 |
| Alice | 357 |
| Chris | 214 |
| David | 444 (Calculated by adding below two values of 333 + 111) |
| Sauruv | 333 |
| Rahul | 111 |
| Alicia | 2345 (Calculated by adding below two values of 2222 + 123) |
| Rohit | 2222 |
| Anish | 123 |
| Ronald | 345 (Calculated by adding below value of 345) |
| Samarth | 345 |
If there is any specific tool or solution that would be helpful in achieving this, that would be very much appreciated!
