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).

BEST PRACTICE For optimal performance and responsiveness, use regular tables instead of pivot tables whenever possible. Reserve pivot tables only for cases where their advanced features are specifically required.

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.