Pivot Table Summarize values

Roman_Chavez 

In your scenario, it seems you want to create a Pivot Table in Excel to summarize Actual Labor Hours without adding up the Standard Labor Hours for multiple employees working on the same Work Order. You can achieve this by customizing the aggregation function for the Standard Labor Hours field in your Pivot Table.

Here is how you can do it:

1. Create the Pivot Table:
• Start by creating your Pivot Table with the relevant fields, including Standard Labor Hours and Actual Labor Hours.
2. Add the Standard Labor Hours Field:
• Add the "Standard Labor Hours" field to the "Values" area of your Pivot Table.
3. Change the Aggregation Function:
• By default, Excel will sum the values in the "Values" area. To change this to a different aggregation function (in your case, you want to avoid adding up Standard Labor Hours), do the following:
• Click on the drop-down arrow next to "Sum of Standard Labor Hours" in the "Values" area of the Pivot Table.
• Select "Value Field Settings."
4. Modify the Value Field Settings:
• In the "Value Field Settings" dialog box that appears, under "Summarize value field by," choose "Max" (or any other suitable aggregation function based on your requirements). This will use the maximum value for each Work Order's Standard Labor Hours instead of summing them.
5. Add the Actual Labor Hours Field:
• Now, add the "Actual Labor Hours" field to the "Values" area of your Pivot Table.
6. Adjust Aggregation for Actual Labor Hours:
• If you want to sum the Actual Labor Hours, you do not need to make any changes since Excel typically sums numeric fields by default.

Now, your Pivot Table should display the maximum Standard Labor Hours for each Work Order (as you mentioned, these should not be added up) and the summed Actual Labor Hours for each Work Order.

This approach allows you to customize how Excel aggregates data for different fields within the same Pivot Table, so you can apply different aggregation functions to suit your reporting needs. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.