back to gallery
Navigate to **Google Sheets** and open the document containing the data you want to analyze.
Click and drag to highlight the range of cells that contains your data. Ensure you include all relevant columns and rows.
Go to the menu and click on **Data**, then select **Pivot table**. Choose whether to place the pivot table in a new sheet or in the existing sheet.
In the Pivot table editor on the right, click on **Add** next to **Rows** and **Columns**. Select the fields you want to analyze.
Click on **Add** next to **Values** to include the data you want to summarize. Optionally, you can add filters to narrow down your data.