Add a pivot table calculation
Prerequisites
-
You have the Insights Author license.
- You have created a pivot table in Insights (see Create a pivot table for instructions).
Page location
Insights > Analyses > Click an analysis > Click a pivot table
Procedure
Add a table calculation to a pivot table
-
In the Values field well, click the three dots next to the field that you want to apply a table calculation to, hover over Add table calculation, and select the function to apply.
NOTE You can't run Total, Difference, and Percent Difference table calculations when a pivot table is being sorted by a measure. To use these table calculations, remove the sort from the pivot table.
Related topics