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.
The view is displaying one content type: Client where all the below fields are available:
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 ?