8 Replies Latest reply on Aug 29, 2018 9:00 PM by Naveen B

    COUNTD on a Calculated Field in my dataset

    pablo.tolosa

      Hello,

       

      I've got a dataset that is like this

       

      NameType
      BanjoDog
      GeorgeDog
      JackCat

       

      Basically I want to add an extra column as a Calculated Field where I can count the number of dogs, cats, in each type, so basically a COUNTD on Name with an IF (Type = Type of this row)

       

      NameTypeCOUNTD
      BanjoDog2
      GeorgeDog2
      JackCat1

       

      How could I accomplish this? Sounds very trivial in my head but I've been stuck a good while.

       

      I know it would be better most likely to not add it as column, but in this case it's what I need for a short term solution.

       

      Cheers,