List.MaxN

This function retrieves the highest value(s) from the specified list, list, after sorting the rows. Users can provide optional parameters to narrow down the results further. The optional parameter countOrCondition indicates the number of values to return or a filtering condition. The optional parameter comparisonCriteria determines how to compare values in the list. list: A list of values. countOrCondition: If a number is provided, a list of up to countOrCondition items in ascending order will be returned. If a condition is specified, a list of items that initially meet the condition will be returned, and no more items will be considered once an item fails the condition. comparisonCriteria: [Optional] Users can specify a comparisonCriteria value to dictate how the items in the list should be compared. If this parameter is left null, the default comparer will be used.