8 Replies Latest reply: Aug 19, 2011 8:17 AM by Alain NICALEK RSS

    Help calculation between months

    Alain NICALEK

      Hello,

       

      I try to create a chart showing the evolution of a stock each month of a year.

      Here is my table

      Month   FTP

      Jan     100

      Feb     150

      Mar     130

      Apr.    160

       

       

      I managed to use Set Analysis when a user selects a specific month, I can calculate the previous month value and then, the difference with selected month.

      sum(FTP)-sum({$<MonthID={$(=Max(MonthID)-1)},Year=,Month=>}FTP)

      If the user selects March it shows -20 (130-150)

       

      But this works only for one month. If I want to display the values for twelve monthes (having Month as a dimension) it does not work. There seems to be some trouble between the set analysis using Month and the dimension of the chart.

       

      I found a way with crosstable and before, having Month as Dimension.

      Sum (FTP) - before(Sum (FTP))

      This gives me the crosstable :

      Jan    Feb    Mar     Apr

      -      50     -20     30

       

      But this only works with a table. Not a chart.

       

       

      How could I create a chart showing a bar for each month, and the bar being the difference between this month and previous month.

       

      Thank you for your help, because I am really stuck.

       

      Alain