1 Reply Latest reply: Oct 25, 2018 11:18 PM by Anil Samineni RSS

    Count of (distinct) values belonging to a list

    Irina Oancea

      Hi,

      I have the following data:

      NameFood
      JohnApple
      JohnBread
      JohnApple
      MaryBanana
      MaryButter
      MaryBread
      MaryOrange
      DanBread
      DanButter

      List of fruits:

      Fruits
      Apple
      Banana
      Orange

      How can I get the count of distinct fruits pro Person? Like below:

      NameCount of Fruits
      John1
      Mary2
      Dan0

      Thanks a lot for your help.