I have a table with column “Cycle”,“value” ,“type” and “media”. I need to sum up the value of the same cycle if the type and media is of certain values.
Cycle|value|type|Media 1 | 123 | A | Air 1 | 132 | B | Water 1 | 234 | A | Air 2 | 122 | A | Solid 2 | 453 | B | Air 2 | 123 | A | Air
In this case, row 1 and 3 has the same type and media and cycle so i need to sum the value together.
Filter table activity can filter the “type” and “media” but if i were to filter cycle too, i have to repeat a lot of times as there are a total of 26 cycles.
Is there a way to better sum the values of the same cycle together after filtering?