2 Replies Latest reply: Jun 11, 2015 8:34 AM by Silvia Assuncao RSS

    Previous Month with Month as dimension

      Hi everybody,

       

      I want to know if this is possible with a Set Analysis to make an expression giving the previous month when the field month is a dimension of my chart ?

       

      Here the Set Modifier would be dynamic and specific for each months ?

       

      Solving this problem would help me to calculate the variation between months.

       

      I don't want to modify the model with the script by placing the value of the previous month on each corresponding row.

       

      Is there somebody who have a solution for this ?

       

      Thanks,

      Vincent

       

      PS : I attached an application trying to illustrate my problem