This template is used for building reports to display the best and worst performers for two separate Accounts or KPI’s. Operating Expenses and Direct Costs is a good example of an Account combination:
What is displayed in this example?
- The two rankings in the top of the screen show the top and bottom 6 Products for an Account, in this case Net Sales. The Account can be changed by clicking on the pick list next to list (1A). By clicking on one of the bars, the Product for the bar charts on the right is changed.
- The two rankings in the bottom of the screen show the top and bottom 6 Products for an Account. The accounts that the user can choose from (2A) are based on an account list which has Gross Margin as a starting account.
- The number of Products in the ranking can be changed with this button.
- To switch between Base Members and Direct Members use this button.
- With this button the user can choose to display the Actual, Budget, Variance or Variance % ranking. In this case Variance is displayed.
- The top right bar chart shows the trend of the selected account (1A) and entity in two categories for the current and previous 5 months. The selected entity on opening of the report is the entity in the POV. But you can change the entity by clicking on one of the entities in the ranking.
- The bar chart in the bottom right shows the trend of the selected account (2A) and entity in two categories for the current and previous six months. The selected entity on opening of the report is the entity in the POV. The entity can be changed by clicking on one of the entities in the ranking.