Forum Discussion
Matrix Row Totals
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
I do not actually have anything under the "Columns" area (see screenshot below). My data is configured so that I have one "Branches" table. Each income/expense category also has its own table, for a total of 6 tables. I then have relationships set up between the "Branches" table and each of the income/expense tables. Then, for this matrix, I pulled in the Branch Name from the "Branches" table and pulled in the sum of each income/expense value for the Values. Should this matrix be configured in a different way?
Thanks,
Matt
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