1 Reply Latest reply on Mar 30, 2016 9:53 AM by Robert Yu

    Sum Medians

    Robert Yu

      Hello,

       

      I have data:

       

      Group, Option, Value, Group Value

      A, 0, 23, 61

      A, 1, 64, 61

      A, 2, 32, 61

      B, 2, 322, 41

      B, 2, 35, 41

      B, 2, 13, 41

      etc.

       

      I am trying to sum the group values across groups. In this case it would be 61 + 41 + etc..

       

      I thought I could do this by creating a measure that creates the median for each group and then sum the measure (as below) but this does not work. Any suggestions?

      What I tried:

       

      1) `Median` --> {fixed [Group]: median([Group Value])}

      2) and then summing across that.

       

      I thought using a LOD would be right because [Group] is not in my bar chart. My bar chart is 3 bars: [Group Value], [Group Value2], [Group Value3]