summaryselectoriginalformula
summaryselectoriginalformula
SUMMARYINFO
,
ROW
,
FORMULA
,
DATABASE

The summaryselectoriginalformula statement returns the formula that will select the original data associated with a summary table row.

Parameters

This statement has four parameters:

summaryinfo – is the name of variable that contains the summary specifications.

row – is the crosstab row that was summary 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 summary table row. 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 summary cell in the original database.

    let clickedRow = info("matrixrow")
    local selectionFormula,originalDatabase
    summaryselectoriginalformula _summaryInfo,clickedRow,selectionFormula,originalDatabase
    topdatawindow originalDatabase
    if selectionFormula=""
        selectall
    else
        execute "select "+selectionFormula
    endif

See Also

History

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