Amazon QuickSight
User Guide

Using Table Calculations in Pivot Tables

You can use table calculations to apply statistical functions to pivot table cells that contain measures (numeric values). Use the following sections to understand which functions you can use in calculations, and how to apply or remove them.

The data type of the cell value automatically changes to work for your calculation. For example, say that 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.