Chapter-1 : Insert a Pivot Table

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
Raw data for pivot table

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
Insert a pivot table

After clicking on Pivot Table option or using shortcut key, below given window will be displayed. click on OK button.

Create Pivot Table Window
Create Pivot Table Window

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
Supervisor wise Sales and Revenue Pivot

Next Chapter