Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This template is used to analyze up to 6 scenarios (Categories) such as Budget, Actual , and Last Year within one main chart over a specified time period which can be monthly, quarterly, etc... It is typical to show the Actual data up to the current period Period and then show either budget Budget or forecast Forecast if it exists for the remaining periods of the year. To view the likely outcome at any selected time period for the specific selected item, e.g. Account, the time period in the side panel can be selected by clicking on the appropriate bar in the main panel display (e.g. to show November on the side panel click on the November panel bar in the main panel display).

In the side panel it is possible to view the selected item from the item selector list broken down by any of the available dimensions for that item. It shows the first 2 scenarios from scenario list, in the first column, e.g. actuals Actuals up to current period and forecast Forecast in the periods beyond the current period. This scenario is then compared with the third scenario in the scenario list, e.g. Budget and a variance indicator is displayed. It is also possible to drill down within the side panel for any alternative dimension that is available.

The remaining 3 scenarios in the scenario list are shown as lines in the report to show and compare the trend against for example Last Year or Rolling Forecast

...

Image Added
1. Item selector - click the drop down to select the required item from the list.

2. Click on any period Period bar in the bars in the main display to set the period Period for the side panel display.

...

4. Drill down the selected dimensional analysis by clicking on the + button the Image Added button next to a member.

5. To expand all the drill downs, click on the Image Added button placed above all the members.