total the Parent rows

System

This discussion was created from comments split from: Parent/Child Rows.

Tomi

How can I use a sum function to just total the Parent rows and not include and of the children rows at the bottom of my table? I dont want to do a sum for each of the cells because they may switch over time. I just want it to know if it is a parent line and automatically summarize it.

Paul Newcome

You will not be able to do that at the bottom of the sheet. You would have to summarize at the top and use hierarchy based functions after indenting properly.

=SUM(CHILDREN())