7 Replies Latest reply: Mar 29, 2011 4:59 AM by Miguel Angel Baeyens de Arce RSS

    Shall I use InMonth function?

    isaac li

      Hi All,

      I have the following 2 tables:

      Usage:
      load * Inline
      [
      MemberId, Category, CompletionDate
      1,IPad,2010/01/02
      1,IPhone4,2010/02/02
      ];

      RegisterTB:
      LOAD * Inline
      [
      Month,MemberId
      2010/01/01,1
      ]

      The first is the orders that customer bought something, the second is the register table that is used to show when the customer became our member.

      Now I want to use pivot table to show how many product the member has bought during the registeration month.

      In this test data, the results shoud be:

      MemberId Month Quantity

      1 2010/01/01 1

      How to calculate that Quantity?

       

      Thanks.