Forum Discussion

Sime's avatar
Sime
Helper I
4 years ago
Solved

Average from Matrix Total

Hi All, I'm struggling to obtain the yearly average, (current and previous years), from the row totals in a Matrix grid.  I had created a measure and applied this to the grid and the monthly ...
General Comment
  • Sime's avatar
    Sime
    4 years ago

    Hi ,

    Thanks for the reply.  I was able to achieve the expected result by creating a subtotal measure and then using another measure to average this value.

     

    Thanks again.

Sime's avatar
Sime
Helper I
4 years ago

Averages are appearing fine for the individual columns but incorrectly for the total.