User`s guide

5.
On the Report menu, click Group Sort Expert.
6.
In the Group Sort Expert, select the type of group sort that you want.
Choose any option except No Sort or All.
7.
Click the Conditional Formula button next to the N or Percentage value field.
8.
In the Formula Workshop, enter the parameter field that you created in step 3.
9.
Click Save and close to return to your report.
10.
Click OK to save your group sort.
11.
When you are prompted to enter a number or percentage, enter the value that you want, and click
OK.
Your report appears with only the number of groups that match the value you entered in your parameter
prompt. To enter a different value, click the Refresh button and choose "Prompt for new parameter
values." The groups in your report are refreshed to show the new value that you entered.
8.4 Subtotaling
A subtotal is a summary that totals or sums numeric values in a group.
Note:
If you are creating a subtotal using database tables that are grouped in a one-to-many linking relationship,
you may need to use a running total instead of a subtotal. See Creating running totals in a one-to-many
linking relationship.
8.4.1 Subtotaling data
In this example you will subtotal Last Year's Sales by Country.
8.4.1.1 To subtotal data
1.
To get started, create a report using the sample database, Xtreme.mdb. Link the Customers table
and then place the following fields from left to right in the Details section:
{customer.CUSTOMER NAME}
{customer.REGION}
{customer.POSTAL CODE}
{customer.COUNTRY}
{customer.LAST YEAR'S SALES}
2012-03-14171
Sorting, Grouping, and Totaling