Summary of Visible Items Only


Note: please send Kudos to this post to 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 list Countries in a module with one line item, RevenueCountries contains USAUKFrance, and Germany. To make things simple, each country has Revenue of 25.

In this module, users can view the revenue from all countries. The default value for All Countries is 100, simple.

P&L All.png

Let's say however, that a user only wants to see the data for UKFrance, and Germany. This user right-click and Shows only these countries. Please can there be an option added such that All Countries equals 75 (and not 100).

P&L Selection.png

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.

6 votes

New · Last Updated


  • Miran
    Status changed to: New
  • Another vote for this functionality.

  • This a very critical requirement from many business users as they analyze based on different criteria and look at summaries filtering the grids based on this criteria.

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!