0 Replies Latest reply: Mar 28, 2012 5:21 PM by Javier Florez RSS

    How to use 'aggr' to show results in another graph?

      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
      x1x2
      x3
      Note
      500450040-Valid. x3 is Null
      5004500405004Valid
      --50165004Not Valid. x2 <> x3. x1 is Null
      5016005016Valid
      -500450045016Not 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.