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.

Can’t sign in to YouTube app on iPad2

I have got the question as to how to keep the video contents into each group on iPad2. I recommend YouTube application to make the playlist. It is surprising that we can’t sign in to YouTube app on iPad2 although the username & password are as same as those of YouTube on the computer. Finally I can sign in and would like to share the following process.

Auto Restart again & again on GT-S3850 CorbyII

Recently I have seen auto restart problem on Samsung GT-S3850. At first I didn’t pay my attention much to this model because it is not the phone running on iOS or Android that I am currently using. However, I have ever used thoroughly the smart phone and the previous versions of the firmware so I gradually pay the interest to look for the solutions for auto restart and stuck in the phone logo.

I have known before that this problem might be solved with the flashing on the phone. As a result, I find the files to be used to restore the phone’s firmware by flashing it.

Reminder + Solution for iPhone 3GS jailbroken

There are the following items to be shared as the reminder and solution for iPhone 3GS jailbroken.

·       Keep away from Restore button on iTunes as it will update your phone to the latest version of the firmware that cannot be jailbroken at that time. (Your iPhone will operate like iPod touch.)

                                

·       If you have the problem with your phone, ensure what solution you will use before restoring your phone with iTunes.

How to root Android Phones

If we know Jailbreak on iPhone, we can easily understand why we need Rooting on Android phone about which we are going to talk.

Rooting on Android phone enables us to utilize the memory on SD card as well as the memory on phone.

Without rooting, all applications we have installed will go to the memory of phone eventhough we have identified the destination of storage, i.e. SD card.

Before jumping towards Rooting, we should check below what we need to prepare & study: