Home > Articles

  • Print
  • + Share This
This chapter is from the book

Summarize Report

The Summarize option enables you to add or remove footer values. You can also use this option to change how the detail values are calculated in the report.

To summarize a report, perform the following steps:

  1. Click the New option to create a new report.

    NOTE: This example uses GO Data Warehouse (query) package.

  2. Insert Product line, Product type, and Quantity in the report.
  3. Click Product line > click Group option in the toolbar.

    NOTE: The Quantity is automatically summarized using the Total function. This is the default.

  4. Click the Quantity column header.
  5. Click Edit Data menu > click Summarize.
  6. In the Summarize window, choose Average.

    NOTE: The Quantity is now averaged.

  7. Click OK.

You can remove any summary from the report by performing the following steps:

  1. Click the column header Quantity > Edit Data menu > Summarize.
  2. In the Summarize window, on the Summary for Footers drop-down list > choose None.
  3. Click OK.

    NOTE: Navigate to the bottom of the page; notice that the footer summary has been removed.

  • + Share This
  • 🔖 Save To Your Account