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?
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!