Allow specific databases to be excluded from column calculations

[interr0bangr]

I’ve got a lot of fields that are named the same across multiple databases so when look at them in a table with multiple levels, they are merged under a single column to save screen real estate.

However, when that column gets calculated, it sums the values from every cell in the column, when I often only want to count the cells from 1 of the databases.

Here’s an example of where I have the same field name on 3 databases, but 2 of those fields are just sums of the 3rd field so the value in the calculated row ends up being 3 times higher than the value I want to display.

Could you please add the option to filter/exclude databases from being included in the calculation row?

[ccollins]

I was about to submit this same idea, but glad it’s already here! Here’s a quick mockup I did to explain the need:

In this example, it’s useful to have a formula to show the total of each group. But at the bottom, it makes no sense to combine both the group sum with it’s children’s amounts.