Report without sub-classes

  • 1
  • Question
  • Updated 11 months ago
  • Answered
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?
Photo of Jay Garland

Jay Garland

  • 1,798 Points 1k badge 2x thumb

Posted 11 months ago

  • 1
Photo of David Robertson

David Robertson

  • 350 Points 250 badge 2x thumb

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
Photo of Jay Garland

Jay Garland

  • 1,798 Points 1k badge 2x thumb
Thanks. I'll leave it as it is and scroll across.
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!