crosstabselectoriginalformula
crosstabselectoriginalformula
CROSSTABINFO
,
ROW
,
COLUMN
,
FORMULA
,
DATABASE

The crosstabselectoriginalformula statement returns the formula that will select the original data associated with a crosstab cell.

Parameters

This statement has five parameters:

crosstabinfo – is the name of variable that contains the crosstab specifications.

row – is the crosstab row that was clicked on (1-N).

column – is the crosstab column that was clicked on (1-N).

formula – variable to receive the formula.

database – variable to receive the name of the original database.

Description

This statement returns the formula that will select the original data associated with a crosstab cell. You can use this to select the original data in the original database, or pass it to another text list or matrix to display the subset in that object.

This example will display the data corresponding to the current crosstab cell in the original database.

    let clickedRow = info("matrixrow")
    let clickedColumn = info("matrixcolumn")
    local selectionFormula,originalDatabase
    crosstabselectoriginalformula crosstabInfo,clickedRow,clickedColumn,selectionFormula,originalDatabase
    topdatawindow originalDatabase
    if selectionFormula=""
        selectall
    else
        execute "select "+selectionFormula
    endif

See Also

- Crosstab Workshop -- tool for two dimensional summarizing, analyzing and charting large amounts of data.
- crosstabdatabaseselectoriginal -- selects original data corresponding to a cell in an exported crosstab database.
- crosstabpopup -- handles a click on a crosstab text list.
- refreshcrosstabdatabase -- refreshes a crosstab database.

History

Version | Status | Notes
10.1 | New | New in this version.