2 Replies Latest reply on Nov 19, 2018 5:14 PM by Rafael Benavent

    How to aggregate data with parameter?

    Rafael Benavent

      What I'd like to do:

      I have a field that contains the following values:

       

      Under 5

      7-12

      Teen

      Adult

      50-65

      Over 65

       

      I would like to add a parameter that contains all the values above, plus some additional ones:

       

      Youth

      Senior

       

      Youth should be the aggregation of Under 5, 7-12, and Teen.

      Senior should be the aggregation of 50-65 and Over 65.

       

      What I've tried:

      So far, I've created a new parameter that contains all the values I'd like (those from the field + the additional ones). I added it to my sheet as a control.

      I've also created a new set called "Youth" and a calculation field as follows:

       

      IF [Type Control] = 'Youth'

      THEN 'Under 5' + '7-12'

      ELSE [Type]

      END

      I know the calculation is wrong. I'm not sure what to do.


      Any help is appreciated.