This template is used for reports that give insight into the variance between two categories Categories for an accountAccount. The report shows the variance Variance trend and a breakdown of the account Account into one analytical dimension. It also gives the ability for a further breakdown of the account Account by any analytical dimension.
...
What is viewed in this example?
- The top left bath bar chart gives a 12 month trend of an Account for two Categories. Usually these Categories are Actual and Budget, but this can be changed in the Report settings. On opening, the bar chart is set to show the 12 month trend. By clicking on Periods (1B) you can change a 12 month trend into a 12 months trend within the current year. By clicking on one of the bars you determine the time period for the two bar charts on the right. You can change the account, which is based on an account list, by clicking on the pick list behind it (1A). In the Report settings you can change the Account list. You can also select the compared categories Categories from the pick list (1C).
- The lower bar chart in the main screen shows the varianceVariance.
- You can toggle between a variance in percentages and absolute values
- The bar chart in the top right gives a breakdown into the direct descendants of one of the analytical custom dimension for the selected account (1A) and the two categories Categories selected in 1 in the current period.
- The lower right bar chart shows the variance in percentage Variance between the two categories Categories selected in 1 1C for the selected breakdown and the current period.