Microsoft KB Archive/59441

= Microsoft Knowledge Base =

File: Creating a Subtotal in a Report
Last reviewed: October 27, 1994

Article ID: Q59441

Summary:

In Microsoft File, to subtotal information in one field (for example, &quot;Sales&quot;) based on information in another field (for example, &quot;Name&quot;), do the following:


 * 1) From the Organize menu, choose Report.
 * 2) Put the fields that need to be sorted (&quot;Name&quot;) in the Sorted area.
 * 3) To get a subtotal for &quot;Sales&quot; for each name in the data file, double-click on the intersection of the &quot;by Names&quot; line and the &quot;Sales&quot; field. In the dialog box that appears, select the desired operation and click OK.
 * 4) Select (click) the Summary Report box.
 * 5) Click the Preview button.