1 2 Previous Next 15 Replies Latest reply on Dec 15, 2016 1:09 PM by Kazumi Nozawa

    Sum Aggregated Keywords

    Kazumi Nozawa

      Hello,

       

      I would like to sum aggregated keywords like this:

      IDKeywords
      AApple
      AApple
      ABanana
      BApple
      BBanana
      BMango
      BApple
      CBanana
      CBanana
      CBanana
      CWatermelon

       

      In this case, the result should be:

       

      ID
      Keywords
      Value
      AApple2
      ABanana1
      BApple2
      BBanana1
      BMango1
      CBanana3
      CWatermelon1

       

      How can I sum those keywords by ID numbers in aggregated data?

       

      Thank you,
      Kazumi

        1 2 Previous Next