Occasionally, when creating a consolidated profit and loss report in Management Reporter, the need arises to add a budget column that would display the total of all of your budgets in each of your companies. However, it may be difficult to determine how to add all of the company budgets into one Column Format.
The solution is quite simple. Change the default company, go into your Column Format, add the budget in the appropriate column then simply change the default company to the next company in line. You will continue this add budget process until all of your company budgets are in separate columns in your Column Format.
After completing those steps, you can total those into one column called the Total Budget Column. Make the individual company budgets non-printing columns. This way, when the report is run, you have one budget column that is consolidating all of the budgets, but when you drill down into each entity in the Tree, you will only see the budget for that entity in that entity’s report.
Multiple Columns in Column Format:
Individual Tree Unit: