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