bindingInfo.setTopNSummaryCol(field, header, measure)

Sets the measure to use in ranking groups. This is equivalent to setting the ‘Of’ measure in the Crosstab Editor.

bindingInfoSetTopNExp2

This function should always be used in conjunction with bindingInfo.setTopN(field, header, number) and bindingInfo.setTopNReverse(field, header, Boolean).

Parameters

field

String: Name of a column to rank

header

StyleConstant.ROW_HEADER or StyleConstant.COLUMN_HEADER

measure

String: Summary formula for ranking

'Sum(column_name)'
'Average(column_name)'
'Max(column_name)'
'Min(column_name)'
'Count(column_name)'
'Distinct Count(column_name)'
'First(column_name1,column_name2)'
'Last(column_name1,column_name2)'
'Correlation(column_name1,column_name2)'
'Covariance(column_name1,column_name2)'
'Variance(column_name)'
'Median(column_name)'
'Mode(column_name)'
'Std Deviation(column_name)'
'Variance(Pop)(column_name)'
'Std Deviation(Pop)(column_name)'
'Weighted Average(column_name1,column_name2)'

Example

Crosstab1.query = 'Sales';
Crosstab1.bindingInfo.rowFields = ['Name'];
Crosstab1.bindingInfo.colFields = ['Region'];
Crosstab1.bindingInfo.measureFields = ['Total'];
Crosstab1.bindingInfo.setFormula('Total', StyleConstant.SUM_FORMULA);
Crosstab1.bindingInfo.showColumnTotal = true;
Crosstab1.bindingInfo.setTopN('Name',StyleConstant.ROW_HEADER,3);
Crosstab1.bindingInfo.setTopNSummaryCol('Name',StyleConstant.ROW_HEADER,'Sum(Total)');
Crosstab1.bindingInfo.setTopNReverse('Name',StyleConstant.ROW_HEADER,false);

bindingInfoSetTopNExp1 1

Either syntax below can be used in component script:

bindingInfo.setTopNSummaryCol             // unqualified
Crosstab1.bindingInfo.setTopNSummaryCol   // qualified

For onInit/onRefresh scripts, and for component and property scripts on other components, the second (qualified) form is required.