Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Matrix Table and formatting subtotals and values

I'm providing my team with sector, sales name and account level data in a Matrix Table and currently I do not want them to see the values so I added conditional formatting to show value font color as white. The problem I have is when I collapse to the various levels - that conditional formatting is applied to the subtotal / total rows which now become the value rows. How can I fix this so the subtotals are always showing? 

Current view: 

 

What I'd like to happen: 

Thanks! 

 

 

  • Read about ISINSCOPE  and adjust your conditional formatting accordingly.

     

    "Hiding"  the values like this is ineffective - users can export all the data.

2 Replies

  • Read about ISINSCOPE  and adjust your conditional formatting accordingly.

     

    "Hiding"  the values like this is ineffective - users can export all the data.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you! I was able to do accomplish what I needed with: ISINSCOPE and HASONEVALUE