Aggregate scoped hours by resource and project

Hi Community,

I have an Assignment report that breaks down the planned hours and planned revenue by project and assignee (we sometimes have many assignees on one task).

For the planned revenue value, I want to roll it up to the resource and project groupings, but I'm having trouble doing so.  I feel like I've read in the past that you can't aggregate a custom column that has a valueexpression calculation in it.  My planned revenue field is a custom calculated column, taking the planned hours for a resource * their job role bill rate.  I had to do this because this is an assignment report, not a task report where planned revenue is a standard field.

Here's what I have:

Can't do a custom field on the assignment object.

Thanks,
Nick