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:

Answers