Try: MAX([% contribution] * SUM([Total Hours]
This assumes the % contribution are consistent (a single value) for each employee.
Thanks, I have made those update to the workbook.
The calculations are working at the employee level but the tool crashes when I try to show subtotals to the
Manager->Employee view. "Cannot blend the secondary data source because one or more of the fields use an unsupported aggregation".
Also, when I show Manager as a stand alone, I get values which are not possible.
Any other suggestions?
You mean beside posting a sample packaged workbook for us to work with?