https://community.qlik.com/t5/Talend-Studio/Sum-date-by-Month/m-p/2315343#M86007 Hi oscarba,<BR />- Can you convert date column to string and extract left 7 chars which is your yyyy-mm part of date.<BR />- use this column in group by clause inside taggregaterow<BR />Thanks<BR />Vaibhav Mon, 30 Jun 2014 06:07:03 GMT Anonymous 2014-06-30T06:07:03Z https://community.qlik.com/t5/Talend-Studio/Sum-date-by-Month/m-p/2315342#M86006 Hello, <BR />I have the simplest (most complex) problem, I have a table with the invoice line items, I want to group those by customer and by month, no problem using tAggregateRow to do the sum, but I need to group my date by month not by day. <BR />47734819 500066 311 2013-10-01 00:00:00.000 L888294 362 362 -55.42 -34.36 <BR />47734820 500066 311 2013-10-01 00:00:00.000 L888294 362 362 -27.60 -17.97 <BR />47734821 500066 311 2013-10-01 00:00:00.000 L888294 362 362 -64.40 -41.93 <BR />47734822 500066 311 2013-10-01 00:00:00.000 L888294 362 362 -7.88 -5.84 <BR />The output <BR />47734820 500066 311 2013-10 362 362 -whateverthe sum -whateverthe sum Wed, 25 Jun 2014 19:53:53 GMT https://community.qlik.com/t5/Talend-Studio/Sum-date-by-Month/m-p/2315342#M86006 Anonymous 2014-06-25T19:53:53Z https://community.qlik.com/t5/Talend-Studio/Sum-date-by-Month/m-p/2315343#M86007 Hi oscarba,<BR />- Can you convert date column to string and extract left 7 chars which is your yyyy-mm part of date.<BR />- use this column in group by clause inside taggregaterow<BR />Thanks<BR />Vaibhav Mon, 30 Jun 2014 06:07:03 GMT https://community.qlik.com/t5/Talend-Studio/Sum-date-by-Month/m-p/2315343#M86007 Anonymous 2014-06-30T06:07:03Z