First select 'Pivot Table' from Insert menu.
A three-page Pivot Table wizard will be loaded. Select the data table on page 1 and press '>>' button.
On page 2, select target range where the pivot table will be placed and press button '>>'.
 | Note Pivot table will be created starting from the upper left corner of the target range and filters will be placed first. |
Select fields for Page, Row, Column and Data options and press 'Done'.
A pivot table report will be created as show below
