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

kim_barragan0126
kim_barragan0126 Member
in Datasets

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.

image.png
image.png

Best Answer

Answers

  • ggenovese
    ggenovese Contributor

    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
    kim_barragan0126 Member

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

  • ggenovese
    ggenovese Contributor
    Answer ✓

    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
    kim_barragan0126 Member

  • DavidChurchman
    DavidChurchman Coach

    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?

    image.png

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories