Highlighted
Occasional Contributor

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?

2 REPLIES 2
Frequent Contributor

Re: Time Dimension with only Year - no months

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

 

Community Boss

Re: Time Dimension with only Year - no months

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