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.

crosstab editor showing Of measure field for ranking groups

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);

crosstab showing top 3 names ranked by Sum of Total measure

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.