Perform math calculation in views

by Aka   Last Updated September 11, 2019 09:07 AM

On my Drupal 8 site, I have a exact copy of the below excel example table made with views but without the yellow cell yet.

View table with calculation

The view is displaying one content type: Client where all the below fields are available:

  • Date
  • Client Name
  • Client ID
  • Amount ($)

Now, as you can see, the yellow cell is displaying the total SUM of all amount ($) rows. which basically is: 15+29+97+115+45+67+23+11+5+91+44 = 542$

How can i achieve this exact calculation in my view ?

I have tried to enable the Use aggregation option under the advanced section on my view, but it seems it doesn't do what i am asking for!

any help please ?

Tags : views 8

Related Questions

Alter the moderation state in the Content view Drupal 8

Updated February 28, 2018 21:07 PM

Group items in Views by value in Field Collection

Updated July 20, 2015 13:03 PM

List of referenced entities appended to a node

Updated January 12, 2017 08:03 AM