Show value of the same month in previous year

Julia Mazur shared this question 3 years ago
Answered

Hi all,


I would like to know how to display the value from the previous year from the same month (e.g., Jul 2018 compared to Jul 2018). More specifically, I would like to display the delta to the value from the same month in the previous year. I know about the advanced function "delta from last", but this does not solve my problem as I have month level data.


Is there a function to calculate this? How can I solve the problem?


Thanks!

Julia

Replies (2)

photo
1

Hi Julia,

Firstly, caveat, I don't work for Yellowfin, I work for a Yellowfin Partner.

Is this the sort of thing you were looking for?

/846da798fb2ad5f8206fa094db305283


Lex

photo
1

Hi all,

yes this is exactly what I need.

Thank you very much.

Regards,

Julia

Leave a Comment
 
Attach a file