I created a table with operations sorted by date. How to display a second array with the total transaction per month ?

I want to show by example the total in September 2016, the total amount of August 2016 ...

Table should display one line per month with the total amount of transactions.

enter image description here enter image description here enter image description here

The same month are not grouped :-(


I would recommend trying to use Views Aggregator Plus

See Example here: https://www.drupal.org/node/2361413 It says a similar thing would work(aggregate and group by column).

God Bless.

  • thank you, but it is doable with "use aggregation: yes" and using filter criteria month ? – user54067 Sep 15 '16 at 8:32
  • @Mathieu I'm not sure what else you could try.. – Sammy7 Sep 15 '16 at 15:27

Maybe you can convert your date field in a PHP format to display 'month YEAR' (like august 2016) and then use grouping on the month + sum on the money field to aggregate on the month. As Sammy7 said Views Aggregator Plus might give you an handy option.

  • I've updated the question. I do not want to use complementary modules. I changed the date format, but I can not regrouler month with the sum – user54067 Sep 15 '16 at 9:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy