You can fulfill the aforementioned requirement by utilizing a window aggregate function through Window Aggregation Node, enabling you to compute the running total of sales. Moreover, you can also calculate the cumulative total within each category by leveraging partition fields.
Configuration Window:
