# Pivot table ## Definition ### [[Nexus - Google Analytics Certificate Course|Google Analytics Certificate]] >[! Definition] >A data summarization tool used to sort, recognize, group, count, total, or average data. ## Examples ### Components of a pivot table: - Rows; displays source data in groups on individual rows - Columns; similar to rows, displays source data as columns - Values; can be displayed as rows or columns and are used to perform summary calculations. - Filter; The are like SQL [[HAVING]] clause as it applies a filter to the grouped data ## Related [[Pivot chart]] ## Resources Resources curated from Coursera/Google. ### Perform calculations | Microsoft Excel | Google Sheets | | --------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [**Calculate values in a pivot table**](https://support.microsoft.com/en-us/office/calculate-values-in-a-pivottable-11f41417-da80-435c-a5c6-b0185e59da77) | [**Create and use pivot tables**](https://support.google.com/docs/answer/1272900?co=GENIE.Platform%3DDesktop&hl=en) | | [**Pivot table calculated field example**](https://exceljet.net/pivot-table/pivot-table-calculated-field-example) | [**All about calculated field in pivot tables**](https://infoinspired.com/google-docs/spreadsheet/all-about-calculated-field-in-pivot-table-in-google-sheets/) | | [**Pivot table calculated fields: step-by-step tutorial**](https://powerspreadsheets.com/pivottable-calculated-fields/) | [**Pivot tables in Google Sheets**](https://www.benlcollins.com/spreadsheets/pivot-tables-google-sheets/) | ### Sort your data | Microsoft Excel | Google Sheets | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | [**Sort data in a pivot table or PivotChart**](https://support.microsoft.com/en-us/office/sort-data-in-a-pivottable-or-pivotchart-e41f7107-b92d-44ef-861f-24430830450a) | [**Customize a pivot table**](https://support.google.com/docs/answer/7572895?co=GENIE.Platform%3DDesktop&hl=en) | | [**Pivot tables- Sorting data**](https://www.tutorialspoint.com/excel_pivot_tables/excel_pivot_tables_sorting_data.htm) | [**How to sort pivot table columns**](https://infoinspired.com/google-docs/spreadsheet/pivot-table-columns-in-custom-order-in-google-sheets/) | | [**How to sort a pivot table by value**](https://exceljet.net/lessons/how-to-sort-a-pivot-table-by-value) | [**Pivot table ascending and descending order**](https://medium.com/actiondesk/pivot-table-ascending-descending-order-in-google-sheets-and-excel-1-minute-ultimate-beginners-8f9f4c560492) | ### Filter your data | Microsoft Excel | Google Sheets | | ----------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------- | | [**Filter data in a pivot table**](https://support.microsoft.com/en-us/office/filter-data-in-a-pivottable-cc1ed287-3a97-4e95-b377-ddfafe79fa8f) | [**Customize a pivot table**](https://support.google.com/docs/answer/7572895?co=GENIE.Platform%3DDesktop&hl=en) | | [**How to filter Excel pivot table data**](https://www.dummies.com/software/microsoft-office/excel/how-to-filter-excel-pivot-table-data/) | [**Filter multiple values in pivot table**](https://infoinspired.com/google-docs/spreadsheet/filter-multiple-values-in-pivot-table-sheets/) | ### Format your data | Microsoft Excel | Google Sheets | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------ | | [**Design the layout and format of a PivotTable**](https://support.microsoft.com/en-us/office/design-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80 "Design the layout and format of a PivotTable") | [**Create and edit pivot tables**](https://support.google.com/a/users/answer/9308944#group_data_in_a_pivot_table "Create and edit pivot tables") | ## Flashcards A data summarization tool used to sort, recognize, group, count, total, or average data. @@@ [[Pivot table]] <!--SR:!2024-11-11,4,270!2024-11-08,1,232-->