How to Add a Percent & Grand Total Column in Cross Tab Crystal

Written by alexander gokhfeld
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Add a Percent & Grand Total Column in Cross Tab Crystal
Crystal Reports software creates reports from the different data sources. (Hemera Technologies/AbleStock.com/Getty Images)

The Crystal Reports software is used to analyse business information and create standard or custom reports. It is capable of building the reports from any data source. The built-in formulas and cross-tabs allow to present the important relationships between the different sets of data. The sum of the data values at the intersection of the columns totals and the row totals is used to add a per cent and grand total column to your Crystal Cross Tab report.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Click the "Start" button in the Windows and select the "Crystal Reports" from the "All Programs" menu.

  2. 2

    Select the "Open" option on the start page, click on the file you want to edit and then click the "OK" button to open your report.

  3. 3

    Click the "Design" tab on the navigation bar.

  4. 4

    Click the "Cross-Tab" option on the "Insert" menu.

  5. 5

    Drag the Cross Tab object into the report when an object frame appears with the arrow cursor.

  6. 6

    Place the object frame in an empty area in the "Report Header" and click the "OK" button to put an empty Cross Tab in your report.

  7. 7

    Right-click the "Cross-Tab" object and select the "Cross-Tab Expert" option from the shortcut menu.

  8. 8

    Select and drag the group names and field items to the Rows area in the "Cross-Tab Expert'.

  9. 9

    Select a summarised field on the "Cross-Tab" tab and then click the "Change Summary" button.

  10. 10

    Select the "Show as percentage of" option, and choose the summary field you want to base the percentage on.

  11. 11

    Click the "OK" button to close "Crosstab Expert". Right-click on the "Row Grand Totals" and select "Totals on Top" to place the subtotal fields below the row cells values.

  12. 12

    Click the "OK" button to add a per cent and grand total column to your Crystal Report.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.