How do I change a grand total from Sum to Average?

kim_barragan0126 · 2025-01-29T22:35:03+00:00

There was an error rendering this rich post.

I have the below pivot table. I want the grand total to be an average, not a total. When I changed the aggregation to average, the grand total line disappeared; see second screenshot. The column Sales Difference is a formula calculated in ETL, so I am not sure if that is the problem.

Find more posts tagged with

Accepted answers

ggenovese

Hello, I'll refer you to the Knowledge Base Article on Summary Numbers which will explain much better than I can. Hope it woks for you!

DavidChurchman

You should be able to get an average in the total row by switching the aggregation to average the way you did. There's something else going on. Maybe a lot of nulls in the data? Or you accidentally clicked "Hide total" option on the measure?

All comments

ggenovese

I don't believe that you can choose an average of a sum in the total row, but you could display the average in the summary number instead.

kim_barragan0126

Thank you. Can you clarify what you mean by the summary number?

ggenovese

Hello, I'll refer you to the Knowledge Base Article on Summary Numbers which will explain much better than I can. Hope it woks for you!

kim_barragan0126

DavidChurchman