How can I total individual elements of a table?



I have a card where I have individual country data calculated as such:


Calculation Capture.PNG

The value of A is calculated simply as:




The countries are in the same group, Europe.  However the Grand Total is simply completing the same "A" calculation across the group.  What I need is a simple sum of the indivdual country values; in this instance 25,896 + 7,545 + 5,937 + 5,492.  This is obviously simple in Excel and most likely the same in Tableau but appears to be a nightmare within Domo!


The data is originally in an Excel, howver I passed it into a Dataflow so as to share the calculations on the data set in an attempt to use a Sumo Card, however I get the same result.


Is there any advice that can be provided on how it can be possible to complete what should be such a simple calculation?