Forum Discussion
Solved
Remove totals in matrix table
How do I remove totals from the rows. When I make a matrix the columns delivers a total for every column, distubing the picture.
According to me marix properties->General->Row Totals on/off should work
You are correct that you can remove totals for tables. However you cannot remove a grand total for a matrix at this time.
I'm really quite surprised that we're not able to turn off grand totals on the matrix visual considering people have been requsting this enhancement for many years. As a work-around I set the font and background color to white - not perfect, but it's OK for the time being.
Another workaround:
If your columns in your matrix consists of measures, then you can dovalue = if(hasonefilter([highest level row column]);[valuecolumn]))
this should make the grand total row blank. and no need to change the colors.
Hi,
This code is not working for me, could you please make it more clear?
