Forum Discussion
Custom Matrix
In excel there is the ability to sum columns but average by row. How do I achieve this in a Matrix?
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.