Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Showing Average instead of Total

I see when you turn on Totals you can see the totals of the columns. Any way to see the average of the columns instead by any chance?   I don't want to show it in a seperate table.    
Need Help
  • A_Scott's avatar
    A_Scott
    Icon for Helper I rankHelper I
    3 years ago

    As of May 2023 this process is no longer an option. There is no longer an "aggregate" option when right clicking over the values. How can we now change the total to an average in a matrix?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I see the values are average now. Is there a way to change the 'Total' word to Average by any chance?

    • DrSmitty's avatar
      DrSmitty
      New Member
      4 years ago

      Under Visual - Row subtotals - Rows - "Subtotal label"

      • soliverc's avatar
        soliverc
        Frequent Visitor
        2 years ago

        Is there any wat to remove decimal places? when you change aggregate mode to average, it adds decimal places. Even thought the type is whole number.

         

         

  • leandroab1's avatar
    leandroab1
    Icon for Advocate II rankAdvocate II
    3 years ago

    Is it still valid? I can't find it.