Interactive
Analyzing Data by Using PivotTables in Excel 2016: Summarize PivotTable Data
BizLibrary
Updated Feb 05, 2019Microsoft Office Excel 2016: Part 4 (Data Analysis with PivotTables) - When you create a PivotTable, Excel automatically totals the data by either summarizing or counting the items, using the SUM or COUNT function, respectively. In addition to these default functions, Excel provides other summary options through two tabs in the Value Field Settings dialog box. (The Value Field Settings Dialog Box, The Show Values As Tab, The Insert Calculated Field Dialog Box)
Related learning
