How to export a Trial balance in excel showing totals of the child accounts and not main accounts

When i export a trial balance to excel it is giving me the totals of both the child accounts and main (group) accounts. However, i want it to show only the child accounts totals in the exported trial balance. How do i achieve this?