You're welcome. As a side note about this "Average" - this is not strictly a 'monthly' average as such... instead, it's a 'column' average. This only matters if, e.g. your secondary-key is 'date', secondary subtotal is 'monthly', and expect Jan-Dec transactions. If there is 1 month missing i.e. transactions on every month except in November, then the subtotal-table will have 11 columns, and the average will be (Jan->Dec total) / 11. This is a limitation of the averaging function which divides total by number of columns, and is rather difficult, or very limiting, to try generate a true monthly average (i.e. I'm not keen of trying this). ~C
On Sat, 13 Oct 2018 at 15:56, Deva - <pobox.d...@outlook.in> wrote: > Thank you! > > That is an interesting use of Transaction report. Interpretation of the > period columns is slightly different from what I had in mind, but this > version of the report should give me what I am looking for, with a little > adjustment in thought process. > > Cheers. > > On 12-Oct-2018, at 8:46 PM, gnucash-user-requ...@gnucash.org<mailto: > gnucash-user-requ...@gnucash.org> wrote: > > Date: Fri, 12 Oct 2018 22:04:40 +0800 > From: Christopher Lam <christopher....@gmail.com<mailto: > christopher....@gmail.com>> > To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> > Subject: Re: [GNC] Feedback: Balance Sheet (Multi-Column) / Income > Statement (Multi-Column) > Message-ID: <b95c4659-4f44-f176-a85f-ab3bdca17...@gmail.com<mailto: > b95c4659-4f44-f176-a85f-ab3bdca17...@gmail.com>> > Content-Type: text/plain; charset=utf-8; format=flowed > > Hi Deva > > Thanks for feedback. > > Charts were planned but not quite finished. > > Period Average is actually present in the Transaction Report. Select > either Asset/Liability accounts, or Income/Expense accounts, (or both). > From sorting tab, select Primary-Key = account-name, Secondary-Key = > date, secondary-subtotal = month, Display / Subtotal table = enabled. > > You'll find monthly subtotals per account in the subtotal table. > > ~C > > _______________________________________________ > gnucash-user mailing list > gnucash-user@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. > _______________________________________________ gnucash-user mailing list gnucash-user@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.
