5 Replies Latest reply: May 20, 2014 3:44 PM by Andres Quinteiro RSS

    Help with expresion to count(if otherexpresion='Yes')

    Andres Quinteiro

      Hello everiboy! I need count rows that the signal is 'SI' in a pivot table. The field Semaforo is other expresion is not a dimension. There is my problem.

      I attached the file.  An example:

       

      NroPedido  Semaforo      IC

      1                    SI                      3

      2                    SI                      3

      3                    NO                    3

      4                    SI                      3

       

      The result for all rows will be three for the expresion IC.

       

      Please I need resolve this problem for my job as soon as posible.

      Thank you! so much!