Thank you to both of you. I have not figured out how to export to a spreadsheet - I tried but only could export to html, added a sum of the column, but the sum gave a total of $0.
-- Stephen C. Camidge scami...@fastmail.fm (519) 363-3912 On Tue, May 7, 2019, at 11:44 PM, Christopher Lam wrote: > Thanks Adrien. > I've realised that unless the multicolumn report is merged into mainstream, > it will never gain enough exposure for bug reports. So perhaps it'll be > better to merge for 3.6 into an 'experimental' submenu within reports. > C > > > On Wed, 8 May 2019 at 13:24, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Stephen, > > > > Comparative-period P&L is not yet implemented in GnuCash. (but as Chris > > Lamm noted, he has a testing version of the report that *might* fit your > > needs - if you can try it, please do so) > > > > You *can* run a multi-column report with each period in its own column, > > but it will get messy with each column having its own row headers, as > > you’ve likely discovered. (you could set all columns to use all accounts, > > show zero balance accounts, and then copy/paste or export to spreadsheet > > and then manipulate from there) > > > > Probably an easier route is to maintain a spreadsheet of your P&L’s and > > paste in each column every period. Be sure to include all account including > > zero balance accounts so everything lines up on the proper rows in the > > spreadsheet. (I use this method along with percentage and variance columns > > that I add) > > > > Regards, > > Adrien > > > > > On May 6, 2019, at 8:35 AM, Stephen C. Camidge <scami...@fastmail.fm> > > wrote: > > > > > > 2) Yes, I can get multi column reports with the Transaction Report, show > > totals monthly by account, but it will not display monthly totals and it > > will not display Revenue separately from Expenses with totals for Revenue > > and for Expenses. > > > > > > _______________________________________________ > > 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. > _______________________________________________ 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.
