Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Matrix table

Hi,

 

I used matrix to make this table. Then I added 2 values from my data to "rows" and then drill down and thats how I have O&G as the section and borstar as the sub.

 

Well for some reason O&G has the data on the rest of the fields when it shouldnt. It should only have data for the "cmputer users" section. Is there a way I can delete or hide the other bold data without messing with the rest of my data on borstar? pretty much hide or delete the bold data on the O&G row but keep what's under computer users on the same row

12 Replies

  • Anonymous on format pane, turn off row total and that will take care of it.

    • Anonymous's avatar
      Anonymous
      Not applicable

      parry2k Yes, but some of them need to be there. I don't want to delete all of the row totals when I need some

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User

        Anonymous that is possible, in that case your each value field you have to put condition and return blank value where you don't want to show the total.