Report without sub-classes

Jay GarlandJay Garland Member Posts: 144
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?


  • David RobertsonDavid Robertson 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 [email protected]
  • Jay GarlandJay Garland Member Posts: 144
    edited January 2018
    Thanks. I'll leave it as it is and scroll across.
  • Jacqui AllenJacqui Allen Member Posts: 243
    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!
Sign In or Register to comment.