<P> Pivot tables are not created automatically . For example, in Microsoft Excel one must first select the entire data in the original table and then go to the Insert tab and select "Pivot Table" (or "Pivot Chart"). The user then has the option of either inserting the pivot table into an existing sheet or creating a new sheet to house the pivot table . A pivot table field list is provided to the user which lists all the column headers present in the data . For instance, if a table represents sales data of a company, it might include Date of sale, Sales person, Item sold, Color of item, Units sold, Per unit price, and Total price . This makes the data more readily accessible . </P> <Table> <Tr> <Th> Date of sale </Th> <Th> Sales person </Th> <Th> Item sold </Th> <Th> Color of item </Th> <Th> Units sold </Th> <Th> Per unit price </Th> <Th> Total price </Th> </Tr> <Tr> <Td> 10 / 01 / 13 </Td> <Td> Jones </Td> <Td> Notebook </Td> <Td> Black </Td> <Td> 8 </Td> <Td> 25000 </Td> <Td> 200000 </Td> </Tr> <Tr> <Td> 10 / 02 / 13 </Td> <Td> Prince </Td> <Td> Laptop </Td> <Td> Red </Td> <Td> </Td> <Td> 35000 </Td> <Td> 140000 </Td> </Tr> <Tr> <Td> 10 / 03 / 13 </Td> <Td> George </Td> <Td> Mouse </Td> <Td> Red </Td> <Td> 6 </Td> <Td> 850 </Td> <Td> 5100 </Td> </Tr> <Tr> <Td> 10 / 04 / 13 </Td> <Td> Larry </Td> <Td> Notebook </Td> <Td> White </Td> <Td> 10 </Td> <Td> 27000 </Td> <Td> 270000 </Td> </Tr> <Tr> <Td> 10 / 05 / 13 </Td> <Td> Jones </Td> <Td> Mouse </Td> <Td> Black </Td> <Td> </Td> <Td> 700 </Td> <Td> 3200 </Td> </Tr> </Table> <Tr> <Th> Date of sale </Th> <Th> Sales person </Th> <Th> Item sold </Th> <Th> Color of item </Th> <Th> Units sold </Th> <Th> Per unit price </Th> <Th> Total price </Th> </Tr> <Tr> <Td> 10 / 01 / 13 </Td> <Td> Jones </Td> <Td> Notebook </Td> <Td> Black </Td> <Td> 8 </Td> <Td> 25000 </Td> <Td> 200000 </Td> </Tr>

Why would i use a pivot table in excel