Reporting a sum of one category of candidate expenses

Summary

Reporting a sum of one category of candidate expenses

Content

I'm working on a report that will tell me what we've paid for relocation expenses by employee group. Some candidates have multiple entries for relocation. How can I sum the relocation expenses per candidate per requisition and keep the data in a format that I can export into excel so I can further manipulate the data?

I was thinking that I could create an expression that would calculate a sum of expense category = relocation. Maybe an IF statement?

If category = relocation then sum category

This is as far as I got: