Forum Discussion

Mike_Sims's avatar
Mike_Sims
Regular Visitor
5 years ago
Solved

Row Subtotal for Matrix

Hi.  I am trying to average each row of a matrix across the columns, in my case years, and was hoping to do so via a subtotal.  Each row is a quick measure.  The first row is an average by each year.  The second row is a sum by each year.  The third row is a division of the second row over the first row... pretty basic stuff.  For each of these rows i need the mean average to show as a subtotal (instead of the sum subtotal).  Currently the First row is giving the average subtotal (assuming this is because it is an average measure) however the bottom two rows are adding.  I can't see easily how to fix this.  Any help would be appreciated.

 

Need to change the subtotal to an average

2 Replies