3 Replies Latest reply: Jul 18, 2012 5:31 AM by Raghavendra Suryakumar RSS

    Growth % calculation

    Raghavendra Suryakumar

      Hi All,

       

      We have a situation wherein weekly performance data is generated for multiple project teams.  The requirement is to calculate the % of improvement based on the weekly data in the graph.  we have below mentioned

       

      TeamDateData
      A Team02-07-20125
      B Team02-07-20126
      C Team02-07-20123
      A Team09-07-20127
      B Team09-07-20129
      C Team09-07-20124
      A Team16-07-20124
      B Team16-07-20125
      C Team16-07-20129

       

       

      For each week, we have to calculate the improvement % based on the data of previous week.  We are able to achieve the same using Pivot table, but need help in achieving the same in Bar graph.