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.

Hi Allan

Take a look at how Summary Filters work. I have a feeling they will solve your issue.

I have to admit they are tricky to use - I have to read the help every time I try.

Steve