groupdown
PERIOD
The groupdown statement divides the database into groups, with a summary record at the end of each group. The groups are arranged in descending order (high to low).
Parameters
This statement has one parameter:
period – identifies the span of each group. This parameter is optional, and only applies if the current field is a date field (it will be ignored for any other type of group). The options for this parameter are listed below. Use the options exactly as shown, with no quotes.
- by Day
- by Week
- by Month
- by Quarter
- by Year
If the current field is a date field and this parameter is omitted, the database will be grouped by day.
Description
This statement divides the database into groups according to the current field. For example if the current field contains company names there will be one group per company, in reverse alphabetical order (from Z to A). If the current field contains zip codes there will be one group per zip code, ordered from high to low. If the current field contains dates it may be grouped by day, week, month, quarter or year, starting with the most recent.
This example calculates totals for each month, with more recent months towards the top.
field Date
groupdown by month
field Debit
total
See Also
- analyzedialog -- opens the standard Analyze dialog.
- average -- calculates averages and sub-averages for the selected records in the current field.
- collapse -- hides the detail records associated with the currently active summary record.
- collapsetosummary -- collapses to the next higher summary level.
- count -- counts all non-empty data cells for the current field.
- expand -- reveals the next level of collapsed detail records associated with the currently active summary record.
- expandall -- reveals all collapsed detail records associated with the currently active summary record.
- groupup -- divides the database into groups, with a summary record at the end of each group. The groups are arranged in ascending order (low to high).
- importdatabasedialog -- opens the standard Import Database dialog.
- info("collapsible") -- checks to see if the current record is collapsible.
- info("expandable") -- checks to see if the current record is expandable.
- maximum -- calculates the maximum and sub-maximums for the current field.
- minimum -- calculates the minimum and sub-minimums for the current field.
- removeallsummaries -- removes all summary records.
- removedetail -- removes data records from the current database, leaving only summary records. It can also delete low level summary records, leaving only higher levels.
- removesummaries -- removes summary records from the current database.
- reverseorder -- reverses the order of the records in the database.
- sortdialog -- opens the standard *Sort* dialog.
- sortdown -- sorts the database by the current field. The database is sorted in descending order (high to low).
- sortdownwithin -- sorts the database by the current field, leaving any previous sorts intact. The database is sorted in descending order (high to low).
- Sorting Data -- sorting data into a specific order.
- sortup -- sorts the database by the current field. The database is sorted in ascending order (low to high).
- sortupwithin -- sorts the database by the current field, leaving any previous sorts intact. The database is sorted in ascending order (low to high).
- total -- calculates totals and subtotals for the current field.
History
| 10.0 | No Change | Carried over from Panorama 6.0. |