Forum Discussion

jamiesonc's avatar
jamiesonc
New Member
5 years ago
Solved

Monthly Growth

Hi all,   I'm trying to display year-on-year growth for a dataset that has monthly data as below My goal is to display the data like this:  Where the top chart is the monthly FYP for ...
Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    TODAY() will give you a date.  YEAR(TODAY()) will give the current year.  Is that what you want?

HotChilli's avatar
HotChilli
Community Champion
5 years ago

TODAY() will give you a date.  YEAR(TODAY()) will give the current year.  Is that what you want?

  • jamiesonc's avatar
    jamiesonc
    New Member
    5 years ago

    Thanks, i think the full question is too lengthy for a forum! this will work for now