Add columns to modules with differences and ratios and between years
Options
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.
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.
Can anyone help me?
0
Comments
-
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.
- Create a line item subset using your "Example" module.
- 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.
1