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


Updated February 28, 2018 21:07 PM

Updated May 26, 2016 09:03 AM

Updated July 20, 2015 13:03 PM

Updated January 12, 2017 08:03 AM

Updated May 02, 2015 23:03 PM