Average instead of Sum in Grand Total of Pivot Table in Google Sheets

user_15851587 0
Viewed 2024

In Google Sheets, is there any way that the "Grand Total" of a column in a Pivot Table is something different than the values of the column represents? (for instance, in a sum column, show the average).

An example would be in a sheet with daily sales of several products. You want in the column for each product to show the yearly sales (sum column), but the grand total to show the average of the values in the column.

enter image description here

This is very easy to do in Excel, since you can configure the Grand Total to be other function. I have not been able to find the same functionality in Google Sheets.

Edit: Original question was badly formulated.

google-sheets
1 Answers

Though it reads Grand Total, the presented result depends on the choices you make on Summarise by as clearly seen in the image.

In our example for Days the Grand Total is the average of all days.
For Points the Grand Total is the minimum of all points

enter image description here

user_15277800
Related