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

Growth % calculation

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

 Team Date Data A Team 02-07-2012 5 B Team 02-07-2012 6 C Team 02-07-2012 3 A Team 09-07-2012 7 B Team 09-07-2012 9 C Team 09-07-2012 4 A Team 16-07-2012 4 B Team 16-07-2012 5 C Team 16-07-2012 9

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.

• Re: Growth % calculation

try this:

=SUM({\$<Team={"A Team"}>}Data)/above(SUM({\$<Team={"A Team"}>}Data),1)-1

PS Your's pivot expression is wrong. You should use above instead before;)

• Re: Growth % calculation

thanks for the suggestion

• Re: Growth % calculation

Hi,

we also have additional table and bar graphs where we have to provide improvements in comparison with the first week of the month and first week of the year.   For example

if the data is like this below

 Team 02-07-2012 09-07-2012 16-07-2012 A Team 5 7 4 B Team 6 9 5 C Team 3 4 9

we need to calculate the improvements with 02-07-2012 weeks data as baseline.  We need the result as

 Team 09-07-2012 16-07-2012 A Team 40% -29% B Team 50% -33% C Team 33% -25%

can you please let me know how to achieve this.

Regards,

Raghav