If you would like to show a subtotal of the wholesale price of a number of items of clothing on a PivotTable of data of both men and women.You have the following fields: Gender, Item and Price.Sum of Price is in the VALUES area.Gender is in the ROWS area.How do you get a subtotal of shirts and pants to display for each gender?
A)Drag the Item field to VALUES.
B)Drag the Item field above Gender in ROWS.
C)Drag the Gender field off the ROWS.
D)Drag the Item field beneath Gender in ROWS.

Question

Quizplus · Accepted Answer

To display a subtotal of shirts and pants for each gender in a PivotTable, you should drag the Item field beneath Gender in the ROWS area. This will group the items under each gender, allowing the PivotTable to show subtotals for each item type (e.g., shirts, pants) within each gender category.

If You Would Like to Show a Subtotal of the Wholesale