How can I get summary subtotal lines on calculated columns?

I have a Gridview report on JobCost details. I have calculated columns with filter for Transaction Date up to RunDate. I can get detail transaction lines and subtotals by Job, but when I summarize on Job, I get <Error!> in all Job subtotal lines and Grand Total line.