Overall Summary on a Subitems Summary Formula Column

Platform discussions
1

Hello,
I wonder how can we add an Overall Summary like regular Columns but on a Subitems Summary Formula Column

image

Thanks!

2

Best way to do that is to ‘summarize’ on parent column. Click the dropdown of the subitem column and select ‘Show Summary on Parent Item’

Screen Shot 2021-07-09 at 11.15.55 AM
Screen Shot 2021-07-09 at 11.15.55 AM1936×522 64.3 KB

2 Likes
3

Hello, thanks for your reply.

If I do “Show Summary on Parent Item” I only sum inside subitems on parent. What I want is a summary of different parent items.

1 Like
4

Hey @Tonin I gotcha, there are a couple extra ways to do that.

  1. add a connect board column and connect the board to itself. Then Mirror the ‘Subitem’ formula from the other related items. And then select the items you want to see the sum of their subitems.

OR

  1. if you just want to see a summary of all the subitems on the board you can create a pie chart or bar chart with X axis as ‘Board’ and Y Axis as the ‘sum’ of all the Numbers column

Option 1

Screen Shot 2021-07-12 at 11.22.30 AM
Screen Shot 2021-07-12 at 11.22.30 AM1366×473 51 KB

Option 2

Screen Shot 2021-07-12 at 11.24.16 AM
Screen Shot 2021-07-12 at 11.24.16 AM779×487 18.6 KB

1 Like
5

Wow! That second option really helped on.
It’s better than a regular summary, thanks a lot!

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.