Below is the raw data for which we have to create pivot table. In this data we have Date, Employee Name, Supervisor Name, Product, Sales and Revenue.
![Raw data for pivot table](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-table-1.jpg)
To insert a pivot table select the raw data and go to Insert tab>>Tables Group>>click on Pivot Table, or use Keyboard shortcut Alt+D+P or Alt+N+V
![Insert a pivot table](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-table-2-300x139.jpg)
After clicking on Pivot Table option or using shortcut key, below given window will be displayed. click on OK button.
![Create Pivot Table Window](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-table-3.jpg)
Now in Pivot Table Field window:
- Drag Supervisor field in ROWS
- Drag Sales and Revenue fields in VALUES
- Drag Product field in FILTERS
Our supervisor wise sales and revenue pivot is ready.
![Supervisor wise Sales and Revenue Pivot](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-table-4.jpg)