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

kim_barragan0126 · January 29

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.

ggenovese · January 30

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 · January 30

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?

ggenovese · January 29

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 · January 30

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

ggenovese · January 30

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 · January 30

DavidChurchman · January 30

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?

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

Best Answers

Answers

Categories