CREATING A PIVOT TABLE IN EXCEL
Purpose:
To summarise and report repetitive rows using data available in the columns.
Input Data:
Now if you would like to summarise the total sales made by North and South (for all dates) or you would like to summarise the total sales date wise (for both the regions), we need to use pivot table.
How to do
Where do I find Pivot Table in Excel 2007 / 2010
Go to “Insert” tab to locate Pivot Table
Where do I find Pivot Table in Excel 2003 or earlier
Go to “Data” menu to locate the same.
First select the entire range of cells from “A1 to A17” and click on pivot table. The screen will look as follows:
Since we have already selected the range, we can proceed further. If we haven’t selected the range, we can select it now. Now press Ok
Now Excel has given a blank pivot report for us to customise the way we need. There is a Field List bar on the right side and we have the blank report on the left side. There are four major things in the field list (on lower part of the menu)
CAclubindia
