This content has been marked as final. Show 2 replies
I can't figure out the good expression to this issue.
I have a table with
2 dimensions : Year & Month each in 2 separates fields
1 variable : Sale
I'd like to display a plot-chart with
Dimension : Year & Month . For this I use monthname(makedate(Year, Month))
Expression : I want to calculate the evolution from the previous year and for the same month
For example, in Aug 08, my calculation must give Sales in Aug 08 / Sales in Aug 07
My question is how to write the good expression for the denominator with my 2 sepatates fields Year & Month
Thanks again for your help and your time.