Forum Discussion
Matrix - replace Total per row with Average
A matrix typically will list totals at collumn and row level. In order to better analyse monthly variances, I would like to compare the lastest month's numbers with the YTD monthly average. So I basi...
There are many ways to do it.
1. Calculate measures separately for each month, and also have measure for average. Then add each into Values field in sequence. Turn off Total columns.
2. Use two separate visual, one for monthly values, and another for average.
3. Use custom visual (R-Visual to create matrix on the fly, or one from the store, that suites your need).
Total column isn't able to do average calculation as far as I know.