Forum Discussion
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
- lbendlin
Super User
Read about ISINSCOPE and adjust your conditional formatting accordingly.
"Hiding" the values like this is ineffective - users can export all the data.
- AnonymousNot applicable
Thank you! I was able to do accomplish what I needed with: ISINSCOPE and HASONEVALUE