Growth % calculation

[raghavsurya]

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. 

[#2]

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;)

[raghavsurya]

thanks for the suggestion

[raghavsurya]

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