SORT and SORTN functions in Google Sheets - Dashboard Guide

Dashboard Mode - SORT and SORTN functions

Dashboard Goal

Find the top 3 salespeople by total sales and see all sales sorted by amount from highest to lowest.

Sample Data

Salesperson	Region	Sales Amount
Alice	East	300
Bob	West	150
Charlie	East	400
Diana	South	250
Eva	West	350
Frank	South	200

Dashboard Components

• Sorted Sales Table: Shows all sales sorted by Sales Amount descending.
  =SORT(A2:C7, 3, FALSE)
  Output: Rows sorted from highest to lowest sales amount.
• Top 3 Salespeople: Shows the top 3 salespeople by sales amount.
  =SORTN(A2:C7, 3, 0, 3, FALSE)
  Output: Top 3 rows with highest sales amounts.

Dashboard Layout

+----------------------+----------------------+
| Sorted Sales Table   | Top 3 Salespeople     |
| (All sales sorted)   | (Top 3 by sales)     |
+----------------------+----------------------+

Interactivity

Adding a filter for Region (e.g., only East) will update both the Sorted Sales Table and Top 3 Salespeople to show only sales from the East region.

Self Check

If you add a filter to show only sales from the West region, which salespeople appear in the Top 3 Salespeople component?

Answer: Bob and Eva appear, since they are the only salespeople from the West region.

Key Result

Dashboard shows all sales sorted by amount and highlights the top 3 salespeople by sales.