Question

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?

Answer 1

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