1
00:00:00,000 --> 00:00:02,563
Here's how to turn raw café orders

2
00:00:02,563 --> 00:00:04,739
into a simple sales dashboard

3
00:00:04,739 --> 00:00:06,408
in Google Sheets.

4
00:00:07,000 --> 00:00:09,001
Line after line of orders shows

5
00:00:09,001 --> 00:00:11,512
very little until you summarize it.

6
00:00:12,100 --> 00:00:15,424
From the Insert menu, choose Pivot table

7
00:00:15,424 --> 00:00:18,185
and click Create. Then add Region

8
00:00:18,185 --> 00:00:21,220
as rows and Revenue as values.

9
00:00:22,400 --> 00:00:25,055
Open Insert again and add a chart.

10
00:00:25,055 --> 00:00:26,818
Google Sheets plots revenue

11
00:00:26,818 --> 00:00:29,312
for each region as a bar chart.

12
00:00:29,900 --> 00:00:32,320
Next, open the Data menu and add

13
00:00:32,320 --> 00:00:34,980
a slicer, set its column to Plan,

14
00:00:34,980 --> 00:00:37,748
then pick Growth plan to filter.

15
00:00:38,367 --> 00:00:39,989
The result: a pivot table

16
00:00:39,989 --> 00:00:42,198
and chart of revenue by region,

17
00:00:42,198 --> 00:00:44,679
with a slicer to focus the view.

18
00:00:45,267 --> 00:00:47,908
Try it with your own data: pivot,

19
00:00:47,908 --> 00:00:50,715
chart, and slice in Google Sheets.