4 Replies Latest reply: Jan 22, 2016 6:10 AM by Sunny Talwar RSS

    Summing by month or by year if havig Date-Data : YYYY-MM-DD HH:MM:SS; Please Help

    Aaron Marsau

      Hey Guys ,

       

      I need your Help.

       

      Im using a Excel-Data which looks for example like this:

       

      DateSales Volume
      2015-01-02 11:22:44:498100,000
      2015-01-05 11:27:44:498200,000
      2015-01-20 11:22:45:498 50,000
      2015-01-25 11:22:44:498 80,000
      2015-01-29 11:22:44:498 50,000
      2015-02-02 11:22:44:498200,000
      2015-02-12 11:12:44:498300,000
      2015-02-18 11:23:54:498400,000
      2015-02-26 11:22:44:498500,000
      2015-02-28 11:22:44:498100,000

       

       

      I would like to have a collective Number for the months and the Year Like this:

       

      Month
      Sales Volume
      2015-01480,000
      2015-021,500,000

       

       

      YearHeader 2
      20151,980,000

       

       

      Tired a view things but it didn't worked.

       

       

      Thank you for your help guys.