What is a Pivot Table? Pivot table is the very useful data
summarization tool in excel sheets (Microsoft, Openoffice.org,
Lotus 1-2-3 etc.). In the simplest way, pivot table can create a
report based on the haphazard data that you enter in the
spreadsheet. No need to sort the columns or adding sum functions
for the columns or any summarization activity. Pivot table do
everything for you. Consider the below excel sheet with a very
simple data, double click on below image to download it The
sample data is, This data shows the number of units sold (Sales)
and models inquired (Inquiry) on a particular date (Date) of a
particular model (Model) of the respective company (Company). I
have created a report with the above data using the pivot table
as below. Double click on below image to download the report:-
The report looks as follows:- Thus, the report shows the Sales
and Inquiry for different company models on 11/2/08. It also
shows total for the company and Grand total of Sales and Inquiry
for that date. I did t