Showing values as percentages

  1. Right-click the blank top-left area of a Cross-Tab and select Cross-Tab Expert from the shortcut menu.

    The Cross-Tab Expert appears.

  2. On the Cross-Tab tab, select a summarized field; then click Change Summary.
  3. In the Edit Summary dialog box, select the Show as percentage of option, and choose the summary field you want to base the percentage on.
  4. Choose Row or Column depending on whether you want your percentage values to be calculated horizontally (row) or vertically (column).
  5. Click OK to close the Edit Summary dialog box.
  6. Click OK to return to your Cross-Tab.

    Summarized field values are now displayed as percentages on your Cross-Tab.