I am trying to find a way to add a field to a pivot table that will automatically calculate the Percent of Labor by a Row Data. See this example: GROUP TASK Minutes AvgMin by Task / Group group1 Task A 10 16.7% Task B 20 33.3% Task C 30 50.0% group 1 ttl 60 group2 Task A 5 7.7% Task B 25 38.5% Task C 35 53.8% group 2 ttl 65 group2 Task A 20 25.0% Task B 40 50.0% Task C 20 25.0% group 3 ttl 80 basically for each task i need to calculate the % of time based on the Total time for the group by task. The excel sheet i am working on is of course much more data and i am looking for a way to automate the field.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Calculate Percent of Total based on Row Sum and Total Sum

Thread starter ajestrab
Start date May 27, 2015

ajestrab

New Member

May 27, 2015

I am trying to find a way to add a field to a pivot table that will automatically calculate the Percent of Labor by a Row Data.

See this example:

GROUP	TASK	Minutes	AvgMin by Task / Group
group1	Task A	10	16.7%
	Task B	20	33.3%
	Task C	30	50.0%
group 1 ttl		60
group2	Task A	5	7.7%
	Task B	25	38.5%
	Task C	35	53.8%
group 2 ttl		65
group2	Task A	20	25.0%
	Task B	40	50.0%
	Task C	20	25.0%
group 3 ttl		80

basically for each task i need to calculate the % of time based on the Total time for the group by task.

The excel sheet i am working on is of course much more data and i am looking for a way to automate the field.