When creating a pivot report, you can choose several functions for the values box by clicking on the Σ sign.

Here is the behavior for each function:

**Sum:**all values are summed**Count:**the number of values is counted**Distinct count:**the number of distinct values is counted**Average:**the average of all values is calculated**Product:**all values are multiplied**Min:**the minimum of all values is displayed**Max:**the maximum of all values is displayed**% of Grand Total:**the following percentage is calculated:

(Value in cell) / (Overall Grand Total for the report)**% of Column:**the following percentage is calculated:

(Value in cell) / (Grand Column Total for the cell)**% of Row:**the following percentage is calculated:(Value in cell) / (Grand Row Total for the cell)**Index:**the following value is calculated:

(Value in cell) x (Overall Grand Total) / (Grand Row Total) x (Grand Column Total)**Difference:**gives the difference with the value of the cell above the current cell.**% of Difference:**gives the percentage of difference with the value of the cell above the current cell.

For example, in the table below, the value of the cell in 2019M05 is 75 and the value of the cell above is 100.

The**Difference**value is equal to 75-100 = -25.

The**% Difference**is (75-100)/100 = -25%.

**Population StDev:**gives the population standard deviation of all values behind the cell**Sample StDev:**gives the sample standard deviation of all values behind the cell**Running totals:**

For example, in the table below, the cumulative value in 2008M01 is equal to 1+4 = 5 and the cumulative value in 2008M02 is equal to 1+4+4 = 9.

## Comments

0 comments

Please sign in to leave a comment.