Don't think so, not for transactional level reporting. Perhaps you can use an external tool to do complex SQL queries. The transaction report, designed a long time ago, cannot be easily transformed to achieve multilevel subtotals, nor subtotals on account parents.
If you don't need the transactional data you can use the Income Statement for Multi level subtotals. On 26 Oct 2017 00:05, "Paul de Vries" <paul.de.vr...@xs4all.nl> wrote: > *From: *Paul de Vries <paul.de.vr...@xs4all.nl> > *Sent: *Wednesday, 25 October 2017 10:07 PM > *To: *gnucash-user@gnucash.org > *Subject: *cannot find report > > I need a transaction report for a given period with total over > sub-accounts, e.g. > > 999 main account > 21 oct transaction $ 1.00 > 999 total for apr $ 1.00 > 999-1 sub account > 22 oct transaction $ 2.00 > 999-1 total for apr $ 2.00 > total for main + sub account $ 3.00 <-- this is the line i'm looking for. > > i remember vagely that i did something like this in the past but i cannot > find it anymore. > > > > On 25 Oct 2017, at 17:12, Christopher Lam <christopher....@gmail.com> > wrote: > > You can run the standard Transaction Report, choose options: > Accounts/Accounts: click a parent account, click “Select Children”; > ***don’t select any other accounts*** > Sorting/Primary Key: account name > Sorting/Primary Subtotal: true > Sorting/Secondary Key: none > This will give you the total for parent + subaccounts. > > I don’t think there’s a facility to report on multiple levels of subtotals. > > Alternatively you can try: from the main account register, select the > parent account, Edit>Open Subaccounts > Then run Report>Account Report. This will give a running balance. But I’m > not 100% sure this is meaningful. > > C > > > thanks. this can only work for a single account where the bottom total is > for the main + sub accounts. > is something like this not possible for multiple accounts with > sub-accounts, separate totals per main account? > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
