Portfolio Archives: CategoriesPivot Tables

You are here:

Calculate values in a PivotTable

calculate values in a pivot table

In PivotTable reports, you can use summary functions in value fields to combine values from the underlying source data. If summary functions and custom calculations do not provide the results that you want, you can create your own formulas in calculated fields and calculated items. For example, you could add a calculated item with the…