Calculation based on string column

I have a table with "CATEGORY " column, which is string and has 5 different values, and sales column which is number.
Now, I need to calculate the percentage of sales in each category value. How can I do this effectively without creating “rule based row filter” node 5 times?

Use Group by node.


Hi there @beezee,

percentage of sales should be calculated within group? Not sure GroupBy will help here. What aggregation method you had in mind @izaychik63?


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.