How to use pivot table in excel 2010 with example

In this example , the data for the pivot table resides  as follows

Next we’ve chosen cells B8 to F13 on sheet1, Select the insert Pivot table,

after that select “OK”

Next, choose the fields to add to the report. In this example, we've selected the checkboxes next to the Order ID andQuantity fields.

we've also selected the checkboxes next to the Order ID, Quantity and Total cost fields.