3 Replies Latest reply: Mar 30, 2017 9:21 AM by Some Nath Roy RSS

    Intersection within set analysis

    Some Nath Roy

      Hi All,

       

      I am looking for a help to write a set analysis for a query. Suppose my data looks as below:

       

      data:

      Load * Inline

      [person,day,sales

      a,sun,10

      a,mon,20

      a,tue,30

      b,thu,22

      c,mon,20

      d,sun,12

      d,mon,11];

       

      I require to show person wise sales having sales on 'sun' AND 'mon' both days. Thus the result table should looks as below:

       

      Person

      Sales

      a30
      d22

       

      Regards,

      Som