Forum Discussion
Grandtotals
Is it possible to move the Grandtotals of a matrix table to the top of the table?
HI mmills2018
You can try creating a Dummy column (Total = "Total" ). This will act as a parent level hierarchy for any categorical column present in same table.
Now, create a matrix with this dummy column and your actual categorical column in "Rows" and measue in "values"
Set the metric to lowest level of data by clicking icon as show below:-
Go to "Format" for Matrix visual -> Go to "Subtotals" section
Set
Row Subtotals = On
Row Subtotal Position = Top
Per Row Level = On
More options would appear
Set Total = Offand rest all = On
Got to "Format" for Matrix visual -> Go to "Row Headers" section
Set
Stepped Layout indentaion = 0
and you table should look like below:-
Amazing! worked perfectly, thank you!!!
3 Replies
mmills2018 - Nothing by default that I know of. You could potentially get there creating your own "hierarchy" and a custom measure but it would be messy
HI mmills2018
You can try creating a Dummy column (Total = "Total" ). This will act as a parent level hierarchy for any categorical column present in same table.
Now, create a matrix with this dummy column and your actual categorical column in "Rows" and measue in "values"
Set the metric to lowest level of data by clicking icon as show below:-
Go to "Format" for Matrix visual -> Go to "Subtotals" section
Set
Row Subtotals = On
Row Subtotal Position = Top
Per Row Level = On
More options would appear
Set Total = Offand rest all = On
Got to "Format" for Matrix visual -> Go to "Row Headers" section
Set
Stepped Layout indentaion = 0
and you table should look like below:-
Amazing! worked perfectly, thank you!!!
