Custom Matrix

[shoeshirt]

In excel there is the ability to sum columns but average by row. How do I achieve this in a Matrix?

[lbendlin]

You create a measure and use HASONEVALUE() to figure out where in the matrix you are (cell, row total, column total, or grand total)  and calculate the measure accordingly.