Pivot Table Features In Google Sheets. Pivot tables in Google Sheets are advanced and capable of sophisticated analysis. The following features are all available in Google Sheets pivot tables: Calculated Fields; Grouping by Date fields; Grouping values into intervals (Pivot Group Rule) Custom Grouping by highlighted values; Sorting; Filtering How to Consolidate Data from Multiple Sheets using a Google Sheets Pivot Table. Here’s how to consolidate data from two or more sheets using a Google Sheets pivot table. Step 1. First, we’ll need to consolidate all the data we want to include in our pivot table. We should also ensure that each cell range follows the same header order. Drag the Field Off the Layout Grid. You can remove a field from your pivot table by dragging the field off the list. For this example, remove the Region field from the Filters area. Select the field and drag it off the Field List with your mouse. Note that, since the Regions filter was already set to (All), the Order Amount values don’t change. Automatic Sheets to Notion values with synced tables. Keep the values of a sheet in Google Sheets in sync with a Notion table. Use this feature to have your pivot tables and data summaries automatically updated in a Notion page. It works with new and deleted rows automatically, and you can use Sheets formulas! Pivot Slicers: If you have structured your data using pivot tables then you may be better off using a “slicer”. This is just another way of saying “filter” for a pivot table. Find them under the menu: Data > Add a Slicer; Visual Design Dashboard Template. One of the most effective ways to learn is to pull apart somebody else’s template. There are Google Sheet add-ons that take the AI-assisted pivot tables a step further. Here, I use the GPT Copilot feature in the Coefficient Add-on to build a custom pivot table, based on my input prompt “what are the total sales by property type” Back to contents. 5. Create Charts Here I am using the function Query (please don’t let the function name to scare you) to merge two tables in Google Sheets. The same formula you can use to merge more than two tables also. Table 1: Table 2: Check these two tables. I am merging the first two columns and then adding their values in the last column. Once you’ve selected a required cell range, click on the Insert tab from the toolbar at the top and then select Chart from the overflow menu. Google Sheets will now add its default chart type to your spreadsheet. You’ll also see a Chart editor sidebar on the right-hand side. Inside the Chart editor sidebar, you can select the table you want sovNFxp.