165k views
4 votes
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.

User Charita
by
6.4k points

1 Answer

3 votes

Answer:

Drag the Item field beneath Gender in ROWS.

User Darren Gilroy
by
6.0k points