Tutorial Pivot Table Excel. The pivottable fields pane appears. Excel should now remember the previous range so you just have to click on ok button a new sheet will be created with the pivot table tools select the fields as shown.
Choose where to place your pivot table. Under choose the data that you want to analyze select select a table or range. You have two options.
Select the cells you want to create a pivottable from.
Click any single cell inside the data set. To get the total amount exported of each product drag the following. To do so highlight your entire data set including the column headers click insert on the ribbon and then click the pivot table button. Select the cells you want to create a pivottable from.
