March 30, 2009 at 4:10 am
I have a simple problem but can't figure out how to implement.
I want to summarise on a group in a report. I have put a total in the table header which gives me a grand total which is fine but I need totals for each group as well.
Cost Centre 1
Name1 Cost1 Cost2 Cost3
Name2 Cost1 Cost2 Cost3
Total Total Total
Cost Centre 2
Name1 Cost1 Cost2 Cost3
Name2 Cost1 Cost2 Cost3
Total Total Total
March 30, 2009 at 4:48 am
In your table you should insert a group, the group will probably be switched on the cost centre field.
Make sure you have a header or footer available on your group.
Put a standard sum expression (as per your grand totals) into the group header or footer area.
Good luck,
Nigel.
Nigel West
UK
March 30, 2009 at 4:57 am
Thanks very much. I had the footer on the report rather than the group. works fine now
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply