What can the PivotTable Report do further to the basic?

I have already written the PivotTable report four times. All of them have involved much the basics to create the report with the designed layout (design). However, to make our report more interesting, we need to use more abilities available in the PivotTable tools (Options) and the conditional formatting. The conditional formatting forms a part of Home tab instead of the PivotTable tools but it can be used to highlight the number on the PivotTable report.

The report, our readers have required today, is not just the report with the sum of values. We all know that they require not only the timely basic report but also the capable report for analysing.  PivotTable report can answer these questions reasonably although the answer is not absolutely complete due to the concern of calculation’s accuracy. Tools (Options) of PivotTable can make the analytical report of which the number can be highlighted with the conditional formatting of Home tab.

Learn by video of PivotTable Report in Tabular Form

The topic video presents the process from the data list to the finished report in the designed visual style.  In accordance with the video, we know where we can insert the PivotTable report from the data list and what we have to do with the field list. Additionally, the dropdown lists within those building functions show the displaying results when we choose them.

We have already talked about the building functions on the several posts so we will focus more on this video at the dropdown lists within the building functions.

PivotTable Reports in Three Forms of Report Layout (Part Three)

 We can use PivotTable Menu to create a new PivotTable report according to PivotTable (Part One). And we know that the data of the list with the labelled columns suits the PivotTable Filed List due to PivotTable (Part Two). As a result, we can have the finished reports in different forms with the provided data. The following details and pictures of the finished reports, Compact, Outline and Tabular, are going to be explained below. 

The PivotTable Reports in Three Forms of the option of Report Layout

 

PivotTable Field List and Data of the list with the labelled columns (Part Two)

In connection with PivotTable (part one), you can build the reports in many ways. However, what the report looks like is another matter. And one thing is for sure, the data you want to turn into the report should be the list with the labelled columns. In order to understand the same thing, you should know about the Field List of the PivotTable Tools.

PivotTable Field List comprises of Fields, Report filter, Column labels, Row labels and Sigma Values.

The table is raised as the example below.

	Month (field header=item label)	Product Type (field header=item label)
Row1	Jan (item)	Computer (item)
Row2	Feb (item)	Computer (item)
Row3	Feb (item)	Others  (item)

How to use PivotTable to build the reports (part one)

PivotTable here is PivotTable in Microsoft excel version 2010. PivotTable can build the report in several forms from the database in the short time. The efficiency of the PivotTable report is variable to the change in options, design and your determination. Start first as to how to build the PivotTable report, part one, and go further to more complicated details next writing so that you can adapt them for your own work.

PivotTable WizardButton 

PivotTable Insert

There are more pictures in the story waiting for your viewing.