Forum Discussion
Solved
Custom Total in Matrix
So I have this matrix that has rates and balances on it, inside each type I have a total, but it gives a flat rate average, when I want it to be a weighted average based on the current balance. I hav...
NJ81858 Right, so as described in those articles, I generally get the measure correct for an individual row. Then, create a new measure that uses that measure for individual rows but performs a SUMMARIZE or GROUPBY for subtotal rows and grand total rows. You can use ISINSCOPE or HASONEVALUE to identify where you are in the hierarchy.
Update: I did get the correct measure, it just won't show up unless there is a subtotal in there with the wrong value.