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)))



      ASubject 141
      ASubject 251
      BSubject 131
      BSubject 241


      Any help much appreciated.