PICKLISTM – Consolidating and Running Multiple Company Income Statements

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.