Message Boards
Register New Posts
 
 
 


Reply
 
Author Comment
 
doug.haynie

Registered: 07/19/10
Posts: 3
Reply with quote  #1 

Most Forecaster users know that the power of reporting is the effective use of rollups.  Rollups can be used in the lines, columns and/or the prompt of a Forecaster report.  Creating a rollup is straightforward enough, but what do you do if the data you need to analyze is not already logically grouped in a rollup?  For instance, you wanted to see the budget vs. actual variances of several non-grouped departments in total.

 

Answer: Use the reporting rollup on the fly.  When you launch your report, you are prompted to select the department.  Use the control and/or the shift key to select multiple departments.  When you do this, the “Summarize” check box appears on the Select Prompts dialog box.  Make sure it is checked and click OK.  The resulting report displays a rollup (total) of the departments you selected.

 

Bonus: Follow the steps above, but do not check the Summarize box to open multiple reports at once.  Try it and then go to the Windows menu option to see that all of the reports opened in different windows.



__________________
Sincerely,

Doug Haynie
Doug.Haynie@MSXGroup.com
415-244-2239
Simplifying Budgeting, Financial Reporting, and Analysis
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Powered by Website Toolbox - Create a Website Forum Hosting, Guestbook Hosting, or Website Chat Room for your website.