Relative Trend

This template is the basis for reports where you want to see and analyse the trend of a ratio for the consolidated level and its direct descendants.

What is viewed in this example?

1. The line chart shows the trend of a ratio between two Accounts for the Entity and descendants of the Entity selected in the POV over the current and previous 11 months. One of these two Accounts is fixed, in this example Gross Margin. The other Account is variable and based on an Account list with Administrative as the starting Account. By changing the variable Account (1A) you change the ratio. It is also possible to turn off one or more of descendants of the in the POV selected entity by un-checking the box (1B) in front of that entity. And by clicking on a line in the chart you can drill down on Entity or change the month. You can also change the compared categories by selecting them from a pick list (1C).
2. The top right bar chart shows the ratio for the current and previous five months for two Categories. By clicking on one of the bars you set the current time to that time period for the entire report.
3. The middle bar chart on the right shows the fixed account for the current and previous five months for two Categories. By clicking on one of the bars you set the current time to that time period for the entire report.
4. The bar chart in the bottom right shows the variable account (1A) for the current and previous five months for two Categories. By clicking on one of the bars you set the current time to that time period for the entire report.