1

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 :-(

Improve this question

2 Answers 2

Reset to default
0

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.

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

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.

Improve this answer
1
  • 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
    Commented Sep 15, 2016 at 9:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.