Click a column header to sort by it; click again to reverse. Sorting answers "which is the biggest", "which closes first", "who was added last".
Empty values sort last in both directions here, so "smallest amount" never means a deal with no amount at all. Decide whether those records belong in the question, and filter them out if they don't.
Sorting works on what the column holds. Dates sort by date, amounts by number, and dropdowns by their labels. If the question is about open deals, filter out the closed ones first: a closed deal still has a close date.