Add columns to modules with differences and ratios and between years

ManuelSampaio
Occasional Contributor

Add columns to modules with differences and ratios and between years

Hi everyone,

 

I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that shows how much it grew from one year to the other.

 

ManuelSampaio_0-1669141228443.png

 

 

In this specific example I want to create something as can be seen bellow with 2 new columns named difference and variation which it is just the difference between the 2 years and the variation on these line items.

 

ManuelSampaio_1-1669141228080.png

 

 

Can anyone help me?

1 REPLY 1
R_Goza
Certified Master Anaplanner

@ManuelSampaio 

 

You can't replicate your example in your current module with native time as a dimension, but you could create a new module and use a line item subset. 

  1. Create a line item subset using your "Example" module.
  2. Create a new module. The dimensions would be the line item subset you created above and your geo/region list (list with US in your example). Line items would be CY, PY, Difference, and Variation. I would recommend using CY and PY instead of FY20 and FY21 so you don't have to update the line item names every year. 
    Screen Shot 2022-11-28 at 2.25.23 PM.pngScreen Shot 2022-11-28 at 2.26.02 PM.png