Running Total -Pivot Table

[ritender.chauhan]

Hello There ,

I want to calculate running total of calculated field item.
e.g. - I have a weekly data set of target vs actual , I want to calculate the no of people meeting target.

from 2nd week onward calculation should be
% people meeting target for week1+ week 2 and so on

							Total for 2 weeks
	Week1
Group	Emp	Target	Achieved	% Meeting Target			Emp	Target	Achieved	% Meeting Target
Group A	X	10	9	90%			X	17	18	106%
Group A	Y	8	11	138%			Y	18	20	111%
	Week2						Running Total- No of emp meeeting target
Group	Emp	Target	Achieved	% Meeting Target
Group A	X	7	9	129%			Group	Week1	Week2
Group A	Y	10	9	90%			Group A	50%	100%
								as only 1 emp meets the target	both emp meets target for combined 2 weeks

 

[pecoflyer]

Hi please post a sample sheet. Pictures or images are impossible to work with

 

[ritender.chauhan]

Hi please post a sample sheet. Pictures or images are impossible to work with

Hello Sir, attaching the sample sheet, thank you in advance

 

[ritender.chauhan]

Hi please post a sample sheet. Pictures or images are impossible to work with

Thanks , I got that sorted out, ran into a new problem now ,

How can I get the count of people meeting cumulative target.



I have the data set of employees with there weekly target and achievement, what I want to calculate is how many people met the target in week 1, and for week 2 ,target and achievement would be ,target of week1+week2 and achievement of week and 2 and so on..



I need the count of people meeting cumulative target .
I would really appreciate you assistance.


attaching new sample sheet for reference


Thanks ,

 

[Nebu]

Hi

May be this?

Thanks