Forum Discussion
Matrix Row Totals
Hello, I have a matrix visual with 6 columns and several rows. Each row represents a building, with the building names being in the first column. The remaining 5 columns then show different incom...
Anonymous
The reason that you cannot see Column Subtotals has to do with the fact that you dont have any fields in columns section. Consider the matrix visual as a pivot table in Excel
The way you use the matrix visual is the same as a table visual. So you can simple turn it into a table visual.
To calculate the total, you need to create a new Measure and sum the fields above (Interest Income, Fee Income, Interest Expense etc).
Then add this measure in values section as last field
Anonymous
Under Subtotals Section --> Turn on Column Subtotals (It is right under Row Subtotals)