Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Don't Summarize Matrix Subtotal?

I have a complex table of logic that needs to contain various subtotals in the Matrix view.  Within the Matrix view I have a list of monthly values that I calculate a monthly percentage.  The Matrix subtotal of the percentage is taking the previous two columns as a calculation instead of the average of the percentage.

I.e. in my screenshot the percentage is showing 56.58/5.91=970.99%.  Instead I would like to see the average of the percentages as an average.

Is there a way to average a single column in a Matrix?  If it matters the % column is a measure not a calculation in the query.  I was hoping to avoid writing a new query to calculate the percentage but I do know how to do that if that is the only resolution.

 

Thanks in advance!

  • Anonymous what is the measure that you are using for %? Why not create a measure with average?

2 Replies

  • Anonymous what is the measure that you are using for %? Why not create a measure with average?

    • Anonymous's avatar
      Anonymous
      Not applicable

      parry2kI didn't even think of that!  That appears to have done the trick!

       

      Thanks so much for your time ğŸ˜€