The following formula still returns headers. =QUERY (Sheet1!A:B,"SELECT A, SUM (B) GROUP BY A OFFSET 1",0) The accepted answer solves this challenge. =INDEX (QUERY (H4:L35;"select sum (L) where H='First Week'"; -1),2,1) This just parses the returned array and selects the 2nd record returned in the first column. To do so, follow the following steps: Step 1: Go to the individual sheet, and add a column that will contain the formula. The label profit is now added to the next column. Step 2: Apply the formula. For our example, the formula for cell H2 will look like this: =E2-G2. Google Sheets will automatically calculate it. Google Sheets also offers a ‘Suggested Pivot Table‘ section which uses AI to analyze your data and suggest the third dimension. 2) Slicer Another feature for creating a dynamic dashboard in Google Sheets is using the Slicer function to “Slice away” portions, so only the selected data remains in visualization. Google Sheets function list. Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and calculate strings and numbers. Here's a list of all the functions available in each category. When using them, don't forget to add quotation marks around all Step 7. Google Sheets allows you to sort your pivot table using multiple sort fields. In the example below, we have two row fields to sort by. The data will be sorted first by country, followed by color. If you would like to change the sort order, simply drag the row elements in the Pivot table editor to match your preferred priority. Google Sheets pivot table builder removes the monotonous task of pivot table creation in Google Sheets. Many times, business users find themselves searching the web aimlessly to find out how to build the perfect-fit pivot table for their use case, which leads to less time focusing on the most important tasks in play. Step 2: Create the Pivot Table. Next, highlight all of the data. Along the top ribbon, click Data and then click Pivot table. Choose to enter the pivot table in a new sheet or an existing sheet, then click Create. In the pivot table editor that appears to the right, add the Product to the Rows, Region to the Columns, and Sales to the Values. Google Sheets can do this for you with literally five steps: Select the range of cells that you want to clear from duplicates. Go to the Data menu => Data cleanup => Remove duplicates. Check whether the selected data range has a header row. Select the columns to analyze for duplicates. Click Remove duplicates. You can change how your pivot table data is listed, sorted, summarized, or filtered. To use pivot tables, go to sheets.google.com on a computer. Create and use pivot tables. GETPIVOTDATA function. To learn about Spreadsheets, Databases, and Query Languages, click the button below: You can group items together inside a pivot table without changing the source data. This tutorial will use example sales data and group it by territory.Learn tQfmdK.