I have a consolidated Income Statement report from 3 Companies. I would however also like to have separate Income Statements for each company. Is there a quick way of creating this?
Yes, make sure the created Picklist is a PicklistM. This allows you to choose MULTIPLE databases or only ONE database at time of running the report.
- Run the Management Pack report and select only 1 database when prompted.
- From the Menu sheet, create an Income Statement but define a new name for this Income Statement.
(You do not want to overwrite the existing consolidated Income Statement)
- Link this template back to the report.
- Run the report out again, selecting the next Database. Repeat the above steps until you have created all the Income Statements for all your Database/Companies.
