Hi @kguehrs and welcome to the forum.
Based on your description, this sounds like a job for some combination of the following nodes:
- Group Loop Start
- Statistics
- Math Formula (or if conditional logic is needed, perhaps Column Expressions)
- Normalizer
- Loop End
Here’s a sample workflow from the Hub that demonstrates some of these nodes in practice - in particular, the looping function.
If you can provide a dummy dataset and some sample calculations you’d like to perform, perhaps someone could help come up with a workflow more tailored to your needs.