@JPollet thank you for the assistance, I was able to sort it out using the Pivot:
- added all necessary Columns to the Groups (in the dummy data: Type, Country, F/M)
- Pivot by any other data, didn’t have affect on my outcome
- Aggregated by the Column that has the numbers I wanted to use for calculation (in the dummy data: Income and aggregation method “Mean”)
Execute this node, and use the middle output port, which is the “Group Totals”.
What I’ve found to be useful addition is a “Missing Value” node, to ensure the success of later calculations
