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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy