In a ClarisWorks database you can copy the results of summary field calculations. After coping this information you might paste it into a spreadsheet (or database) for further manipulation and charting.
For example, using a database of invoices you would produce a layout that gives a breakdown of the sales by salesperson.
1. Choose Insert Part... from the Layout menu and select Sub-Summary when sorted by: Salesperson.
2. Define the following field: TotalSales (summary, number result) = SUM ('Invoice Total').
3. Then use the Insert Field... command to place the field TotalSales on your layout and move it into the area above the Sub-Summary label.
4. Sort by Salesperson.
This database would then display your breakdown in Page View. In order to copy the total sales for each Salesperson:
5. Press the Enter key to ensure that no records are selected.
6. Choose Copy Summaries from the Edit menu or press Command-C (Mac)/Ctrl-C (Windows).
Once pasted into a spreadsheet, the summary field data from each occurrence of a Sub or Grand-Summary part will be displayed in a different row. Each field will appear in a separate column, displaying the summary information from left to right in the order that the fields were defined.
If you want their names, as well as the data, you'll need to create a Summary field as follows, and place it in the Sub-Summary part as well:
SalespersonName (summary, text result) = 'Salesperson'