Note: please send Kudos tothis postto get it on the roadmap.
Please can either model builders or end users have the option to toggle the summary method used on lists where it is possible to view the total of visible items only.
For example, consider a listCountriesin a module with one line item,Revenue.CountriescontainsUSA,UK,France, andGermany. To make things simple, each country hasRevenueof 25.
In this module, users can view the revenue from all countries. The default value forAll Countriesis 100, simple.
然而,假设that a useronlywants to see the data forUK,France, andGermany. This user right-click andShowsonly these countries. Please can there be an option added such thatAll Countriesequals 75 (and not 100).
There will need to be a visual cue that the total is being based on the selection rather than all list items.
Personally, I feel that this behaviour should be the default behaviour. Especially when considering how totals work in Excel tables. I believe that users would expect the total value to only include visible items.