Bottom K Values

Return the nth number of bottom values for a column

Function:

Bottom_Values(table = string, col = string, num_values = integer, new_table_name = string)

 

Parameters:

Table: Table name on which to perform function

col: Column for which to return the bottom

num_values: The number of rows to return for with bottom values. For example if you want the bottom 5 values then input the number 5

new_table_name: The name of the new table with the nth number of bottom values

 

Examples:

Bottom_Values(table = Budget, col = Amount, num_values = 10, new_table_name = Bottom_values_Budget)