6 Replies Latest reply: Jan 3, 2018 9:26 AM by Anil Samineni RSS

    Avg of Previous month vs Current month

    kvp kumar

      Hi All,

       

      I have the data on month on month. I were struct in calculate  average of current month vs previous month .

      Also i have created the master calendar to get the months as fiscal  year.

      The data is like below

      MonthValue
      Mar100
      Apr120
      May90
      Jun80

       

      The required outut is

      MonthPrevious month valuecurrent ValueAvg
      mar100
      Apr100120110
      May12090105
      Jun908085


      To show the output in  table i am getting the output properly, but when i use the same expression for the line chart it was not giving the correct value .

      Can any one help me on this to show these results in a line chart .


      Thanks in advance


      Thanks

      Kumar KVP