Hi, I have a big problem trying to show some data. In the Excel attachment is the information that I have in a graph, but I need to display information that is in column A (only 5004 or 5016), that column is an Expression, rule 1: is not valid that two columns have different data (5004 or 5016), rule 2: at least 1 column must have 5004 or 5016
=If(match(x1,5004,5016)>0 AND ((x2 = x1 OR x3 = x1) OR (x2 = 0 AND x3 = 0) OR (IsNull(x2)=-1 AND IsNull(x3)=-1)),x1,
If(match(x2,5004,5016)>0 AND ((x1 = x2 OR x3 = x2) OR (x1 = 0 AND x3 = 0) OR (IsNull(x1)=-1 AND IsNull(x3)=-1)),x2,
If(match(x3,5004,5016)>0 AND ((x1 = x3 OR x2 = x3) OR (x2 = 0 AND x1 = 0) OR (IsNull(x2)=-1 AND IsNull(x1)=-1)),x3)))
Examples:
Consolidate
| x1 | x2
| x3
| Note
|
---|
5004 | 5004 | 0 | - | Valid. x3 is Null |
5004 | 5004 | 0 | 5004 | Valid |
- | - | 5016 | 5004 | Not Valid. x2 <> x3. x1 is Null |
5016 | 0 | 0 | 5016 | Valid |
- | 5004 | 5004 | 5016 | Not Valid. x1 <> x3 and x2 <> x3 |
The idea is show only when in Column A is 5004 or 5016. x1, x2 and x3 are in diferent tables and I can´t to filter them bucause sometimes any value is Null. I think to use the function aggr, and use this graph to create another, but I can't to find a good example.
Thank you.