8 Replies Latest reply: Mar 27, 2013 9:41 AM by Manoranjan Ayyaswamy RSS

    How to Count only the exclusive items in a given aggregated set ?

    Manoranjan Ayyaswamy

      Hi,

       

      I have below data

       

      TYPEMEMBER_ID
      AM1
      AM2
      AM3
      BM1
      BM2
      BM4
      BM5

       

      When I aggregate based on Type, and Count the members I get below result:

      TYPE      TotalCount
      A3
      B4

       

      But, what if I need to Count exclusive members in each Type.

      Please note M3 is exclusive only to type A, and M4 & M5 exclusive only to type B. So I want the below result in my Straight Table.

       

      TypeTotalCountExclusiveCount
      A31
      B42

       

       

      Please help.

       

      Thanks

      Mano