Pivot Layout and Pivot Table Field List

Pivot table data source to show pivot table option in excel

Pivot Layout and Pivot Table Field List for explanation of Pivot table example

Create Pivot Table Option
Pivot Table Final Output