This template is used for reports that give insight into the variance between two categories for an account. The report shows the variance trend and a breakdown of the account into one analytical dimension. It also gives the ability for a further breakdown of the account by any analytical dimension.
What is viewed in this example?
- The top left bath 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). You can also select the compared categories from the pick list (1C).
- The lower bar chart in the main screen shows the variance.
- 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 selected in 1 in the current period.
- The lower right bar chart shows the variance in percentage between the two categories selected in 1 for the selected breakdown and the current period.