When inserting a PivotTable, which option allows you to display the sum of values by a specific category?

When creating a PivotTable to analyze and summarize data, it is essential to select a meaningful categorization that aligns closely with the data you wish to evaluate. In this case, the option "Sum of Bonus by Employee" allows for an aggregation that is specific and directly related to individual performance metrics within a clear category—employees.

Using this approach, the PivotTable will display the total bonuses allocated to each employee, thus providing insight into compensation distribution based on employee categories, which is particularly useful for performance analysis or budget allocation.

The other options, while they reference sums for various categories,

• "Sum of Sales by Category" suggests a categorization based on product sales rather than individual performance.
• "Sum of Costs by Project" focuses on expenses per project rather than individual contributions.
• "Sum of Expenses by Date" could involve a time-based analysis but lacks the categorization around individual performance.

These options do not target the aggregate of bonuses per employee as effectively, missing the opportunity to analyze compensation trends at the employee level.