Forum Discussion
NickHoffmans
4 years agoFrequent Visitor
Separate conditional formatting on matrix subtotals and values
Hello, I have a matrix in which I want to apply to both the (sub)totals as well as on the values below. However, I would like to have the conditonal formatting applied separated from each other, in...
NickHoffmans
4 years agoFrequent Visitor
I am aware of the "apply to"-button. However, if click "Values and totals" it will count them together.
However, I would like to have two separate ranges (one range for "Values", one range for "Totals") to apply the different conditonal formats to.
mh2587
Super User
4 years agoTry to handle this with measure Just define the ranges and color codes in switch function may be this logic will resolve the issue