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.

...


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  button next to a member.

5. To drill down expand all the dimensionsdrill downs, click on the  button placed above all the dimensionsmember.