Forum Discussion
How not to show values for sub items
I have a matrix looks like the below Is there a way I can only showing the Project A, Project B, Projecct C, Project D, etc. on the GROUP MS row? Currently it's a value in the ...
Thanks Vicky. I think this is what i want to use. Two issues
1) For the variable [Your Project Measure or Value] -> i can't actually put in any column value (it can only be measure, like min or maxing something)
2) Once I added this value into the Values of the matrix. I lose all the child rows, i.e., after i expand the MS group, there are nothing in side.
Thanks!
vicky_
Super User
Super User1) you will then need to sumamrize, or use SELECTEDVALUE([ColumnName]) if there's only 1 value per row
2) i'm a bit confused - didn't you just want the values in the upper-level of the groups? you can replace BLANK() with whatever you want to see in the children rows.