3 Replies Latest reply on Nov 28, 2016 3:25 PM by Shinichiro Murakami

    How to add averages based on groupings of the same measure?

    Jon Iverson

      I have a data source with two columns of information, one is the category name and the other is the Measure (a number).

      Say I have categories named "A" and "B".  I want to perform the following calculation:

      Avg[measure] if category =  "A"  + Avg[measure] if category = "B".

       

      I also have more categories names than just A and B. So I want results for multiple combinations of categories.

      A+B

      B+C

      C+D

      A+C

      A+D, etc.

      What is a good way to set this up?