When you have created a Master Detail report, any calculations that you inserted into the report are broken up into individual sections. You can insert a grand total at the bottom of the report by taking the following steps;
- Scroll down to the bottom of the report so that you can see the last section .
- Click on any blank area of the report and you will see the Section Lines appear.
- Holding down the <Ctrl> key, click on the cell containing the word 'Sum' and on the cell containing the section total. These should both be highlighted.
- Click on Edit at the top of the page and choose Copy.
- Right click with the mouse on the blank area below the last Section Line and choose Paste. Your grand total will now appear at the bottom of your report.
|