Forum Discussion

KimStenager's avatar
KimStenager
New Member
10 years ago
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.
Need Help
  • Tsanka's avatar
    Tsanka
    10 years ago

    According to me marix properties->General->Row Totals on/off should work

brycedwhite's avatar
brycedwhite
Frequent Visitor
7 years ago

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.

 

solvisig's avatar
solvisig
Icon for Advocate III rankAdvocate III
7 years ago

brycedwhite

Another workaround:
If your columns in your matrix consists of measures, then you can do

value = if(hasonefilter([highest level row column]);[valuecolumn]))

this should make the grand total row blank. and no need to change the colors.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, 

    This code is not working for me, could you please make it more clear?