summarydatabaseselectoriginal
CROSSTABINFO
The summarydatabaseselectoriginal statement selects original data corresponding to a cell in an exported summary table database.
Parameters
This statement has one parameter:
crosstabinfo – Name of variable that contains the summary specifications.
Description
This statement selects original data corresponding to a cell in an exported summary table database (created with the Summary Workshop). It also brings the original database window to the front.
See Also
- aggregate( -- calculates an aggregate (sum (total), count, minimum, maximum or average) by scanning specified records in a database.
- Crosstab Workshop -- tool for two dimensional summarizing, analyzing and charting large amounts of data.
- crosstab( -- converts information in a database into a crosstab table (tab delimited text).
- formulasum -- calculates a total by scanning a database, returning the accumulated sum of evaluating a formula over and over again for each scanned record.
- groupdatepattern( -- converts a number representing a date into text in a special format for use with the summarytable( and crosstab( functions. The function uses a pattern to control how the date is formatted (see Date Patterns).
- refreshsummarydatabase -- refreshes a summary database.
- Summary Workshop -- tool for quickly summarizing, analyzing and charting large amounts of data.
- summaryselectoriginalformula -- returns the formula that will select the original data associated with a summary table row.
- summarytable( -- scans a database to build a text array containing summary breakdown information: totals, averages, etc.
- summarytablepopup -- handles a click on a summary table text list.
History
| 10.1 | New | New in this version. |