2 Replies Latest reply: Sep 7, 2010 7:23 PM by John Witherspoon RSS

    Issue with set analysis

    Jean-Jacques Jesua

      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