Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.

Sometimes it's hard to see the big picture when your raw data hasn’t been summarized. Your first instinct may be to create a PivotTable, but not everyone can look at numbers in a table and quickly …

Build PivotTables by using related tables in the Field List. You can import related tables from databases, or set relationships in Power Pivot after you import.

After you create a PivotTable by selecting its data source, arranging fields in the PivotTable Field List, and choosing an initial layout, you can perform the following tasks as you work with a PivotTable:

You can create multiple page fields and assign your own item names for each source range. This lets you create partial or full consolidations; for example, one page field that consolidates Marketing and …

After you create a PivotTable, you'll see the Field List. You can change the design of the PivotTable by adding and arranging its fields. If you want to sort or filter the columns of data shown in the …

You can use Agent Mode in Excel to create pivot tables and edit your workbook, Copilot Chat to ask basic questions, or explore with Analyst for deep reasoning data analysis.

Group by date and time Name a group Ungroup grouped data Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also Create a PivotTable to …

Create a PivotTable (pivot table) by connecting to an external data source like an Access or SQL Server data base or an Online Analytical Processing (OLAP) cube file.

When working with a PivotTable, you can display or hide subtotals for individual column and row fields, display or hide column and row grand totals for the entire report, and calculate the subtotals and …