7 Replies Latest reply: Sep 30, 2014 4:56 PM by Jonathan Poole RSS

    Return calculated value from pivot for set dimension

      I am trying to return the results of a calculated value while looking at one set dimension for a pivot. For example I have a pivot looking at the Grade and Gender of a person and want to return the results of only a Gender of M regardless of what the actual Gender is of the line. I have an example of my data below, the expected result always returns the avg rate of the Grade for the M Gender.

       

      GradeGenderAvg RateExpected Result
      1F6050
      M5050
      2M7070
      3F8090
      M9090

       

      I have tried many different expressions but cannot get any to consistently return the right value.

       

      Thanks,
      Matt