Forum Discussion
filter matrix visual on multiple column condition
Hi everyone, I need help doing some visual filter on matrix across multiple columns. (please see below screenshot) If [Sum Clicks] and [Prev Month Sum Clicks] are both 0 at the same time (MUST be b...
Try:
Sum clicks not 0 =
IF(AND([Sum clicks] ==0, [Prev Month Sum Clicks] ==0), BLANK(), [Sum Clicks])
Prev Month Sum clicks not 0 =
IF(AND([Sum clicks] ==0, [Prev Month Sum Clicks] ==0), BLANK(), [Prev Month Sum Clicks])
Try:
Sum clicks not 0 =
IF(AND([Sum clicks] ==0, [Prev Month Sum Clicks] ==0), BLANK(), [Sum Clicks])
Prev Month Sum clicks not 0 =
IF(AND([Sum clicks] ==0, [Prev Month Sum Clicks] ==0), BLANK(), [Prev Month Sum Clicks])
This method works!! Thank you so much!