Crystal Reports  

Adding Percentages to a Report

You can calculate the percentage of one group within a broader grouping. For example, you could show the sales in each city as a percentage of the total sales for each country. Or, you could show each country's percentage contribution to the grand total of sales.

To calculate a percentage

  1. Right-click in the Crystal Reports ActiveX Designer to access the shortcut menu.
  2. Point to Insert and click Summary.
  3. In the Insert Summary dialog box, select the field for which you want to calculate the sum.
  4. In the second drop-down list, select Sum.
    Note   The "sum" calculation appears in the list only when a field containing numeric data is displayed in the first drop-down list.
  5. Select the summary location.
    Note   :    The summary location cannot be Grand Total (Report Footer) when you are calculating a percentage.
  6. Select the Show as a percentage of check box.
  7. In the Show as a percentage of list, select the group you want the percentage based on.

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

  8. Click OK.

    The summary percentage field is added to your report.

See Also

Grouping Data | Enhancing Report Presentation