Report without sub-classes

Jay Garland
Jay Garland Member Posts: 130
edited January 2018 in Accounts Hosted
I want to generate a P&L by class. When I generate the report it has columns for the sub-classes and a total column for the class. I don't want the sub-class columns in the report - just the class totals. How can I do this?

Comments

  • David Robertson_9018461
    David Robertson_9018461 Member Posts: 20
    edited January 2018

    Hi Jay

    There is no feature to hide the sub classes and run a report showing classes consolidated at the top level, or any other level. You options are to download the report to Excel.

    Alternatively I support a report writer that can do this for you. If you want to know more about the report writer solution contact me at davidr@afpconsulting.com.au
  • Jay Garland
    Jay Garland Member Posts: 130
    edited January 2018
    Thanks. I'll leave it as it is and scroll across.
  • Jacqui Allen
    Jacqui Allen Member Posts: 238 ✭✭
    edited January 2018
    It very simple to export to excel, just make sure that auto outline is ticked in the advance tab. Once you open excel you will see above and to the left of the first cell numbers which collapse the columns/rows.  
    If it doesn't work discard it!