Hello @deltaselect,
Thank You for posting your query onto the Forum.
To fix the totals issue, one of our expert @Greg had created a specific post onto the forum which addresses this exact same issue. The post contains the used cases of scenarios as well as the link of the videos about how to fix them.
Below is the link provided for the reference.
Hoping you’ll find this useful and helpful and will meet your requirements that you’ve been looking for. 
Note: To view the entire post, please click onto the link and not onto the “expand/collapse” button.
Thanks and Warm Regards,
Harsh