1 Reply Latest reply on Dec 6, 2018 1:40 PM by Jim Dehner

    Help with grouping values from a calculation


      I have a calculation that summarizes a $ amount at the category level for each person. I'm using this formula { FIXED [Person],[Category]: SUM([$])}

      Now I want to group people into different buckets depending on the $ amount for the category total.

      So say I choose Animal, I would like to group people into buckets of <20, 20-30, 31-50 etc


      Is it possible to do that on a calculated field?



        • 1. Re: Help with grouping values from a calculation
          Jim Dehner

          Good afternoon

          the process for doing that is

          1. convert your fixed formula to a dimension
          2. right click it
          3. select convert to dimension
          4. then click it as a dimension and create bins



          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          1 of 1 people found this helpful