Matrix subtotals average and sum

[Anonymous]

Hello All

I've got a matrix visualisation that I'm trying to get the sub-totals to be either sum or average depending on the level:

Product Group (row)

   Product Name (row)

      Version (row)

         Colour (row)

            Quantity (value)

I'd like the subtotal of the colours to be the Sum of the quantity  and for the other rows the subtotal should be the average of the sum in the colour subtotal

I've tried various custom measures and can get some of the right subtotals but not all.  Any help appreciated.

[pranit828]

HI @Anonymous 

Please explain with sample input and output

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.