PivotTable Percentages - Total Column Correct; Weekly Columns Not

[futureprimitive]

Hi everyone,

I'm trying to create a PivotTable that shows labor utilization by week. When I use the 'Show Values As... % of Parent Column' function, the running total column is correct by employee, but the individual weeks are not.

Every other default option (% of parent row, row, column, etc.) didn't give the desired result.

Photo attached for reference -- top table is the Actual Data, second table is the Incorrect Pivot Result using method above, third table is the Desired Pivot Result that I can't seem to figure out.

Any ideas?

 

[GlennUK]

Use 2 PivotTables, each doing the calculation you want, and pull the results into a dashboard afterwards.

 

[RoryA]

Which version of Office do you have (it would be wise to update your profile to show that)?

If you have Power Pivot, you can create a measure to calculate that.

 

[futureprimitive]

I'm using Excel 365 (desktop version)