1 Reply Latest reply on Oct 26, 2018 3:21 PM by Deepak Rai

    How to sum total count at a distinct detail level

    Brynne Miller

      I'm working with a data set that has single line items dedicated to each detailed feature of a single package. However, also in this data set is the users tied to that package (not feature).

       

      I'm trying to get a total sum of all users at the package level, but can't figure out how to get it to not add up all counts in the data set, and to just add the sets tied to the unique package level.

       

      Example of what i'm looking for below:

       

      example data

       

      PackageFeatureCompanyCount
      A1Red1200
      A2Red1200
      A1Yellow750
      A2Yellow750
      A1Blue50
      A2Blue50
      B1Green400
      B2Green400
      B3Green400
      B1Pink 1000
      B1Purple200

       

       

      What i'm looking for:

       

       

      PackageTotal
      A2000
      B1600

       

       

      What i'm getting

       

      PackageTotal
      A4000
      B2400