8 Replies Latest reply on May 2, 2018 12:46 PM by Yanbin Cen

    Urgent! Single Calculation Field for Three Layers Average

    Yanbin Cen

      Hi All,

       

      I have an urgent issue that need your talent!

       

       

      I have a data set that has following columns: Aspect/Risk/Themes/Theme_Score where each aspect has multiple risks while each risk has multiple themes. Suppose there's no theme overlapped among any risk, and the same of risk over aspect.  I'd like to know if it would be possible to have a single calculation field that would give me the actual average of each aspect, risk, and theme with help of the filters. I've set filters for aspect,risk,theme. Take the following table as an example, I'd like to have a single calc field so that when I choose A2,R3,T4, it would return 4; when A2,R3,and all relevant theme, it would return (4+5+6)/3=5; when A2 and all relevant risks, and themes, it would return [(4+5+6)/3+7/1]/2=6.

       

      Thanks a lot!

       

      Karen

      Aspect
      Risk
      Theme
      Score
      A1R1T11
      A1R2T22
      A1R2T33
      A2R3T44
      A2R3T55
      A2R3T66
      A2R4T77