Time Dimension with only Year - no months
Hi All,
I am trying to bring in only Year data (no month or Quarter) but I do not seem to have only Years when I choose the Time.
I am trying to get data for FY16, FY17, FY18, and then trying to do average of FY16 and FY17, and FY17 and FY18.
I tried hiding the months, however, when I use the Period or Lead or Lag, it looks at the month.
Any ideas?
Tagged:
0
Answers
-
Hi @khoonks,
In the Blueprint mode of your module, choose Year as Time Scale (See attached screenshot),that will give you only Year and you can also use Lead/Lag functions.
Thanks
Sathya
2 -
You can also use Movingsum to have a rolling two year average
See below for more details
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/MOVINGSUM.html
David
0