User`s guide

You return to the Field Explorer dialog box.
11.
Place the running total field in the Details section of your report, just to the right of the Orders.Order
Amount field.
Note:
If you want to view a grand total of each group, place the running total field in the Group Footer
section of your report.
9.2.3 Creating conditional running totals
There may be times when you have a list of values, and you only want to subtotal some of the values
in the list. For example:
• You have a list that contains both Canadian and U.S. customers.
• You want to keep customer records sorted alphabetically based on customer name.
• You do not want to break the data into groups based on the country.
• You want a total of the values from just the Canadian records.
• You also want a total of the values from just the U.S. records.
To accomplish this, create two running totals, one to keep a running total of the U.S. records, and one
to keep a running total of the Canadian records.
• USTotal
Maintains a running total of the U.S. records.
• CanadaTotal
Maintains a running total of the Canadian records.
9.2.3.1 To create a conditional running total
1.
To get started, create a report using the sample data, Xtreme.mdb. Link the Customer table, and
then place the following fields from left to right in the Details section:
{customer.CUSTOMER NAME}
{customer.COUNTRY}
{customer.LAST YEAR'S SALES}
Note:
Xtreme.mdb is located on the SAP Business Objects Support web site.
2.
On the Report menu, click Record Sort Expert.
2012-03-14185
Running Totals