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...
parry2k
Super User
Super UserAnonymous 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.
parry2k How do I do this? Where? Can you walk me through this please
- parry2k
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] )