Percentages

Calculating a percentage

You can calculate the percentage of one group within a broader grouping. For example, you can show the percentage of sales in each city based on the total sales for each country. Or, you can see what percentage of the grand total of sales each country contributes.

To calculate a percentage

1. On the Insert menu, click Summary.

   The Insert Summary dialog box appears.

   

2. Enter sum in the first drop-down list.
3. Select the field for which you want to calculate the sum.

   For example, you may want to insert a field which calculates the sum of last year's sales.

4. Select how you want the data grouped.
5. Click the Show as a percentage of check box.
6. Select the group you want the percentage based on.

   You can choose to show a percentage of a group within another group, or show a percentage of the grand total.

7. Click OK. The summary percentage field is added to your report.