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

Calculate the nth largest value in the specified column.

Parameters

tableLens the tableLens object of the table

n the nth largest value to search

column column label of the column to summarize

condition condition on the column to summarize

Return

nth largest value in a column

Example

text = nthLargest(Table1.tableLens,2,'Quantity',
   "Discount>0");

See Also

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

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