Months without years

[Elirana]

Hello,

I have sales dates variable with full date which from it ,i just need to isolate the month and the year.

In the other hand,i have objective for each month without year in the variable,so when i am trying to Associate it to the sales month that i created ,it is not working properly as the objective has no year.

lets say the objective is for all the years,how can i add year for it?

thank you

[ArnadoSandoval]

Hi @Elirana 

Have you try month - script and chart function ?

Hope this helps,

[javiersassen]

Hi Elirana,

"lets say the objective is for all the years,how can i add year for it?" easiest way? don't add year!

If you link the objective to the month field, selecting a year value won't do anything with the objective table. See attached image. Hope this helps