For example, we have a table with columns for Country, State, Sales, SqM. In the pivot we will group by Country and then State, and in order to get a Sales / SqM column, we need to add it as a calculated field in the Pivot table. It would, on a record basis, calculate the total sales divided by the total sqm. In Excel we use a calculated field inserted into the Pivot table to do this.