5 Replies Latest reply: May 23, 2017 8:28 AM by Sunny Talwar RSS

    Set Analysis

    Christopher Ellis

      Could someone help please , I have got so far with this but need to take it further.

       

      The set analysis below aggregates a percentage for each subject when selected.

       

      What I want to do is combine subjects, for example all selections of subject where the Key is the same and Level 4 or higher exist in all the subject selections for that key. The table below would give 50% because only Key A matches both criteria when Subject 1 and 2 are selected together.

       

      (Sum(aggr(Count({$<[Level]={">=4"}>}distinct Key),PU,Subject)))/(Sum(aggr(Count(distinct Key),PU,Subject)))

       

       

      KeySubjectLevelPU
      ASubject 141
      ASubject 251
      BSubject 131
      BSubject 241

       

      Any help much appreciated.

       

      Thanks

       

      Chris