30.9k views
5 votes
Given a list of candy in a field called Item and prices called Price on an empty PivotTable, how would you find out how many of each type of candy you have?

User Dnivra
by
7.0k points

1 Answer

6 votes

Answer:

Drag Item to both the VALUES and the ROWS area

Explanation:

To find out how many of each type of candy you have; Drag Item to both the VALUES and the ROWS area

User Crashtor
by
7.1k points