Use table calculation in pivot tables

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

You can use table calculations to apply statistical functions to pivot table cells that contain measures (numeric values).

The data type of the cell value automatically changes to work for your calculation.

EXAMPLE   You apply the Rank function to a currency data type. The values display as integers rather than currency because rank isn't measured as currency. Similarly, if you apply the Percent difference function instead, the cell values display as percentages.

Topics in this section

Use the following pages to understand which functions you can use in calculations and how to apply or remove them.

• Add or delete pivot table calculations
• Functions for pivot table calculations
• Ways to apply pivot table calculations