Forum Discussion
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
- parry2k
Super User
Anonymous on format pane, turn off row total and that will take care of it.
- AnonymousNot 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
Super 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.