WEBVTT

00:00:00.300 --> 00:00:01.654
Here's how to build

00:00:01.654 --> 00:00:04.452
a sales dashboard in Google Sheets.

00:00:04.902 --> 00:00:06.519
Select the top-left corner

00:00:06.519 --> 00:00:09.102
so the full dataset is highlighted.

00:00:10.002 --> 00:00:12.482
With the table selected, open the Insert

00:00:12.482 --> 00:00:15.279
menu to add something based on this data,

00:00:15.279 --> 00:00:18.066
and choose Insert from the top toolbar.

00:00:18.966 --> 00:00:21.229
From Insert, choose Pivot table

00:00:21.229 --> 00:00:22.734
to open setup.

00:00:23.634 --> 00:00:25.661
Keep New sheet selected,

00:00:25.661 --> 00:00:28.194
then create the pivot table.

00:00:29.094 --> 00:00:30.894
In the Pivot table editor,

00:00:30.894 --> 00:00:32.694
add a field under Rows.

00:00:33.344 --> 00:00:35.064
Region is already in Rows,

00:00:35.064 --> 00:00:37.424
and the table updates on the left.

00:00:37.424 --> 00:00:38.905
Add a field under Values

00:00:38.905 --> 00:00:41.360
so the pivot can summarize a metric.

00:00:42.698 --> 00:00:45.475
The pivot now shows Region and Revenue.

00:00:45.475 --> 00:00:47.538
Open Insert again so we can add

00:00:47.538 --> 00:00:50.162
a chart based on this summary table.

00:00:50.862 --> 00:00:52.534
A column chart appears,

00:00:52.534 --> 00:00:55.614
then the view returns to the source sheet.

00:00:56.435 --> 00:01:00.035
Under Data, add a slicer for filtering.

00:01:00.935 --> 00:01:02.634
Set the slicer column

00:01:02.634 --> 00:01:05.183
to Plan in the side panel.

00:01:05.833 --> 00:01:07.666
Open the Plan slicer values

00:01:07.666 --> 00:01:10.502
and clear Growth plan so the chart filters

00:01:10.502 --> 00:01:12.433
to the remaining option.

00:01:13.133 --> 00:01:15.013
The slicer, pivot table,

00:01:15.013 --> 00:01:18.053
and chart stay visible on the sheet.

00:01:19.216 --> 00:01:21.454
The sheet now shows a pivot chart

00:01:21.454 --> 00:01:23.080
with a Plan slicer.