Add sum of remaining values in addition to total

unknown

When filtering the layout by let's say the top customers, I'd like to know how much am I missing. Right now using "Keep Totals" I can infer the rest of the values. But that is a tedious task, best done in excel.

 

I'd like to have an option "add remaining sum" that would create a new row above the totals' row. The content would essentially be the totals minus the above rows.

It could look like this:

That would show how relevant the selection is in comparison with the total value.

Monisha Jain

Hi, thank you for sharing your idea! We appreciate the time and effort you put into crafting your suggestion, and we understand the need of this solution. We have accepted this Idea to be part of our backlog and we are evaluating the feasibility of adding it to the development roadmap. 
 
We are committed to delivering the best possible experience to our customers, and we must prioritize the features and enhancements that will have the most significant impact on your daily use of our software.