SELECT clause in Google Sheets - Dashboard Guide

Dashboard Mode - SELECT clause

Dashboard Goal

Show a list of products and their sales amounts using the SELECT clause in the QUERY function.

Sample Data

Product	Category	Sales	Region
Apples	Fruit	100	East
Bananas	Fruit	150	West
Carrots	Vegetable	200	East
Dates	Fruit	120	South
Eggplants	Vegetable	180	West

Dashboard Components

• Product Sales Table: Shows product names and sales amounts.
  Formula: =QUERY(A1:D6, "SELECT Col1, Col3", 1)
  Explanation: Selects columns A (Product) and C (Sales) from the data including headers.
• Total Sales: Shows total sales amount.
  Formula: =SUM(C2:C6)
  Explanation: Adds all sales values from the Sales column.

Dashboard Layout

+---------------------+-----------------+
| Product Sales Table  |  Total Sales    |
| (SELECT Col1, Col3) |  (SUM C2:C6)    |
+---------------------+-----------------+

Interactivity

Adding a filter for Category or Region will update the Product Sales Table and Total Sales to show only matching rows.

Self Check

If you add a filter to show only Category = 'Fruit', which products appear in the Product Sales Table and what is the new Total Sales?

Key Result

Dashboard shows product sales using QUERY's SELECT clause and total sales sum.