Getting the Sum/Total of Salary based on Job Role

Hello and Good day.

I wanted to ask what is the right plugin or solution when trying to get the total/sum of a certain role.

image

So, I have in my Excel File a Role that consists lots of roles and I want to get their total/sum AnnualSalary of that specific Role.

For example:
AE Developer - 5 people
TotalCombinedSalaryAnually - $500,000.

How do I get the total combined salary of the 5 AE Developers.

Please see the workflow attached. I think I am on the right path I just can’t visualize the flow of it.

Have you tried using the Group By step? You can configure Group By to group by developers and perform a sum aggregation.

1 Like

Thanks, Seema! Group By Step worked out perfectly.

1 Like