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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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
7 years ago

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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k How do I do this? Where? Can you walk me through this please

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      Anonymous here is example of one of the measure, instead of Duration field, use following Duration Measure and you will see in case of "O&G", it will give you blank() value, and you have to create similar measure for each and every Field you are using Value pane in matrix visual.

       

      Duration Measure = 
IF( NOT SELECTEDVALUE( Table[Active Projects] ) IN { "O&G", "ABC", "XYZ" } ),
SUM( Table[Duration] 
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        parry2k It's not working, is there another way to approach this?