...

Data fields have different settings for how to aggregate and compute the data. The first of these is Summarize Values By, which determines the function used to aggregate the data, for example, Sum, Count, Average, Min, Max etc. The second is Show Values As, which allows you to change how the aggregation is display. For example, you can specify that you want to do a sum, but show the values as a percentage of the column total.

Next Steps

Those are the basics of PivotTables. To learn how to use PivotTables with ExcelTemplate, see Templates and PivotTables. To learn how to create or manipulate PivotTables with ExcelTemplate, see Creating a Basic PivotTable or our PivotTable API reference.