To put sub- totals in a report.

S

Sergio Mund

Example: John 3 21,8
4 3,2
Sub: 7 25,00

Paul 3 2,7
4 1,3
2 1,1
Sub: 9 5,1

Total: 16 30,1

How to insert a sub-total of the itens and at the end the total?
Thanks.
 
M

Marshall Barton

Sergio said:
Example: John 3 21,8
4 3,2
Sub: 7 25,00

Paul 3 2,7
4 1,3
2 1,1
Sub: 9 5,1

Total: 16 30,1

How to insert a sub-total of the itens and at the end the total?


Use the Sorting and Grouping window (View menu) to create a
group (with footer) on the person field. Then add text
boxes to the group footer section. One with an expression
like =Sum([number field]) and the other like
=Sum([value field])

The exact same expressions can be used in the report footer
to display the grand total.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top