If you click on More Options…, you can select other functions such as Standard Deviation and CountNumbers.

Just right-click inside of the PivotTable → Go to Summarize Values By → Select the summary function Change summary function in PivotTable If you’re a regular user of Excel PivotTables you might know you can change the summary function: For example, the two database tables shown in below each contain a column of invoice numbers, but because the column headings (field names) are different in each table ( Invoice_Number versus Invoice#), the new Auto-Detect feature will not create the join.Yes, you read the title of this post correctly, you can calculate the median and lots of other functions in Excel PivotTables besides the regular options. Note 2: The Auto-Detect joining process works only when common field names are used across the various database tables if the field names do not match exactly (they don't have to have the same case to match exactly), the join needs to be created manually. Note 1: For the Auto-Detect tool to work, each database table must first be converted to an Excel Table, using Excel's Insert, Table, Create Table menu option. However, Excel 2016 makes this process a little easier with an Auto-Detect button that can compare multiple database tables to identify common field names, and then establish the join(s) automatically. Automatic relationship detection: In Excel 2013, pivoting two or more sets of data was a more difficult operation because you had to use Excel's Relationship tool to define the connecting field names between the separate database tables - a process often referred to as joining the databases. Microsoft has made several improvements to Excel 2016's PivotTables. What new PivotTable features, if any, have been added to Excel 2016?Ī.

Pivot charts mac excel 2013