nthLargest(n, column[, group[,condition]])

Calculates the nth largest value in the specified column inside a group. This function is only available to elements within a Section.

Parameters

n the nth largest value to search

column column label of the column to summarize

group column label of the group to summarize

condition condition on the group to summarize

Return

nth largest value in a group

Example

text = nthLargest(2, "Quantity","State",

   "field['Discount']>0");

See Also

nthLargest(n, cellRange), for the Table version.

SI.22, Section Object, for additional functions pertaining to Sections.

Sections, for scripting issues related to Sections.

<< mode(column[, group[,condition]]) © 1996-2013 InetSoft Technology Corporation (v11.5) nthMostFrequent(n, column[, group[,condition]]) >>