1 00:00:00,300 --> 00:00:01,654 Here's how to build 2 00:00:01,654 --> 00:00:04,452 a sales dashboard in Google Sheets. 3 00:00:04,902 --> 00:00:06,519 Select the top-left corner 4 00:00:06,519 --> 00:00:09,102 so the full dataset is highlighted. 5 00:00:10,002 --> 00:00:12,482 With the table selected, open the Insert 6 00:00:12,482 --> 00:00:15,279 menu to add something based on this data, 7 00:00:15,279 --> 00:00:18,066 and choose Insert from the top toolbar. 8 00:00:18,966 --> 00:00:21,229 From Insert, choose Pivot table 9 00:00:21,229 --> 00:00:22,734 to open setup. 10 00:00:23,634 --> 00:00:25,661 Keep New sheet selected, 11 00:00:25,661 --> 00:00:28,194 then create the pivot table. 12 00:00:29,094 --> 00:00:30,894 In the Pivot table editor, 13 00:00:30,894 --> 00:00:32,694 add a field under Rows. 14 00:00:33,344 --> 00:00:35,064 Region is already in Rows, 15 00:00:35,064 --> 00:00:37,424 and the table updates on the left. 16 00:00:37,424 --> 00:00:38,905 Add a field under Values 17 00:00:38,905 --> 00:00:41,360 so the pivot can summarize a metric. 18 00:00:42,698 --> 00:00:45,475 The pivot now shows Region and Revenue. 19 00:00:45,475 --> 00:00:47,538 Open Insert again so we can add 20 00:00:47,538 --> 00:00:50,162 a chart based on this summary table. 21 00:00:50,862 --> 00:00:52,534 A column chart appears, 22 00:00:52,534 --> 00:00:55,614 then the view returns to the source sheet. 23 00:00:56,435 --> 00:01:00,035 Under Data, add a slicer for filtering. 24 00:01:00,935 --> 00:01:02,634 Set the slicer column 25 00:01:02,634 --> 00:01:05,183 to Plan in the side panel. 26 00:01:05,833 --> 00:01:07,666 Open the Plan slicer values 27 00:01:07,666 --> 00:01:10,502 and clear Growth plan so the chart filters 28 00:01:10,502 --> 00:01:12,433 to the remaining option. 29 00:01:13,133 --> 00:01:15,013 The slicer, pivot table, 30 00:01:15,013 --> 00:01:18,053 and chart stay visible on the sheet. 31 00:01:19,216 --> 00:01:21,454 The sheet now shows a pivot chart 32 00:01:21,454 --> 00:01:23,080 with a Plan slicer.