Add Sum Row to Report?

[diofree]

Hi all,
I have a report like in the screenshot below and would like to add a sum row below each Candidate Grouping level to show a roll up of their +-.

I want to achieve something like the grey shaded row in my screenshot, is this possible?

I managed to get this working for the Assessed Score column, because this is a column from the query, but I don't see how to do this for the Gap column, because I added this manually as a column in the report where I simply subtract Required - Assessed.

 

[plog]

You'd do it the same way. Subtract the Required total from the Assessed Total:


=SUM(Required) - SUM(Assessed)

 

[diofree]

Silly me, thanks plog.