I have a subitem column with numbers. Using the “Show summary on Parent Item” feature I can basically get a total sum (other options available like “Average”, “Median”, “Min” and so on) of the all the rows in that column. If I have 5 rows and each row has 2 as a value I will get 10 as a result of the “Sum” operation. See picture for more detail.
Unfortunately, if I now apply a filter to the subitem and as a result only get 3 rows displayed the value shown at the parent level will still display the total of the 5 rows (10 in this case) and not the total of the displayed rows (3 would be my expectation)
Board unfiltered
Parent item - total 10
- Parent item - total of all columns = 10
-
- Row 1 - 2
-
- Row 2 - 2
-
- Row 3 - 2
-
- Row 4 - 2
-
- Row 5 -2
View of board after applying filter
- Parent item - total of all columns = 10
-
- Row 1 - 2
-
- Row 4 - 2
-
- Row 5 - 2
This is quite misleading and not so obvious if the numbers are not trivial and you have a huge board.
Suggestion would be to find a way to display the total of the view and not leave the number being displayed as the sum of all rows untouched.
Eg. (6)10 (as in 6 out of the total which is 10) or 6/10
Something like this would avoid some confusion when using filters