[GNC] report subaccounts totals on stacked barchart

D. sunfish62 at yahoo.com
Tue Feb 1 07:25:06 EST 2022


Mattia,

I believe you want to experiment with the Account Level setting. It controls how far down into the account hierarchy the report displays. It will total up lower level accounts into the parent if they are also selected accounts. 

Unfortunately, you can't set different levels for different types of account, as you indicated; there is one setting for the whole report.

My workaround would be to create separate reports for each "level" report, and put them side by side on a multicolumn report. 

HTH,
David T.


-------- Original Message --------
From: Mattia Rizzolo <mattia at mapreri.org>
Sent: Tue Feb 01 06:25:24 EST 2022
To: gnucash-user at gnucash.org
Subject: [GNC] report subaccounts totals on stacked barchart

Hi!

My liabilities have this (pretty common, I think) structure:

Liabilities
 |-AP
 | |- x
 | |- y
 | |- z
 |
 |-Credit Cards
 | |- Bank1
 | | |- x
 | | |- y
 | |
 | |- Bank2
 | |- Bank3
 |
 |-Loans
 | |- Bank1
 | | |- Loan1
 |
 |-Security Deposits     # this is money I'm keeping as deposit
 | |-Apartment1          # for an apartment I'm renting out
 |
 |-Tax Provision
 | |-2021
 | | |- Tax1
 | | |- Tax2
 | |
 | |-2022
 | | |- Tax
 | | |- Tax2

In this, only the leaf accounts actually contain transactions, all the
others are marked as "placeholder".

Now, I'd like to have 2 different "Liabilities barchart"s:
* one very detailed that contains all possibile stacks
* one that contains only the branch totals plus some subaccounts

I'm having troubles figuring out which options I should pick in the
report settings to get the latter.  I'd like to see a barchart
containing a stack for each of the following:
 * AP
 * Credit Cards:Bank1:x
 * Credit Cards:Bank1:y
 * Credit Cards:Bank2
 * Credit Cards:Bank3
 * Loans
 * Tax Provision:2021
 * Tax Provision:2022
Basically, I want specific stacks for all of the credit cards, but only
the total of the other categories.

Currently, if in the report account selection I pick the higher level
account, nothing is shown on the report, probably because it's not
considering the subaccounts.  If I click the "Select Children" button,
then it goes and shows all subaccounts with each subaccounts with one
stack (which is the "detailed" variant that I do want in the other
case).


I'm using gnucash 4.8, I'd be glad if anybody can show me if and how to
accomplish my goal! :)
Thank you in advance!

-- 
regards,
                        Mattia Rizzolo

GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540      .''`.
More about me:  https://mapreri.org                             : :'  :
Launchpad user: https://launchpad.net/~mapreri                  `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list