Set Up a Pivot Table
You have to place the desired available fields in the correct area of the pivot table by selecting the desired field and dragging it towards the desired area (drag and drop)
Another way of adding a field to the pivot table is by selecting the desired field and choosing the area at the bottom of the window Available fields and clicking on Add to.
After setting up the pivot table, you still have to save it by clicking on Save on the menu bar.