5 Replies Latest reply: Jul 21, 2014 5:16 AM by Ashfaq Mohammed RSS

    Count value and classify

    Gabriele Boccassini

      Hi,

      I've a table like this:

       

      Header 1field1field 2field 3field 4field 5
      value 1YNNYN
      value 2YYYNY
      value 3NNNYY
      value 4YNNYN
      value 5YNYNY

       

      I want to obtain a table:

      Classcount
      Class A5
      Class B8

      where A is the count of "Y" in field 1 and field 2 and b is the count of "Y" in other fields.

       

      How??

       

      Thanks