5 Replies Latest reply: Aug 16, 2014 6:18 PM by Marco Wedel RSS

    Grouping data by month and person

      Looking for some help here

       

      I have a table of sales data per day by employee like so:

      Employee IDDateNumber sold
      110/08/20143
      111/0820145
      216/08/20146
      219/09/201412
      221/09/20142

       

      Which I want to convert to a table in the following form:

      Employee IDMonthTotal sold
      1August8
      2August6
      2September14

      Basically, total sold by employee for each month. This is probably really easy and I am too tired to work it out, but any help would be much appreciated