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?

Question

asked Sep 8, 2022 31.0k views

1 Answer

Crashtor · Answer 1 · 2022-09-14T12:31:31+0000

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