Issue with set analysis

[#1]

Hi,

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.

JJJ

[#2]

Any help, pls

JJ

[johnw]

I suggest that you combine the Month and Year together into a real field. Calculated dimensions can be slow. They also would be rather complicated to use with my suggested solution, which is to handle it like in the attached file.