Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a data and wanted to create pivot tables
Solved by M. D. in 22 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/08/2018 - 02:15
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern. :)
Excelchat Expert 02/08/2018 - 02:17
From what you posted, it seems you need assistance in creating a pivot table from you data. May you please share the file so we could further assess the content and structure? Thanks!
User 02/08/2018 - 02:20
Excelchat Expert 02/08/2018 - 02:20
Okay, nice You can upload your file here by clicking on the green clip to the right and selecting your file.
User 02/08/2018 - 02:20
I just wanted for you demonstrate how to create pivot tables
User 02/08/2018 - 02:20
you can use dummy data that you have
Excelchat Expert 02/08/2018 - 02:20
Okay I see. In that case, I can thus provide step by step instructions in creating pivot tables then.
Excelchat Expert 02/08/2018 - 02:21
Okay, noted on that. :)
User 02/08/2018 - 02:21
Excelchat Expert 02/08/2018 - 02:21
Do you wish to create a pivot table in google sheets or excel?
User 02/08/2018 - 02:21
Excelchat Expert 02/08/2018 - 02:22
Okay, let me create a sample pivot table and upload it here. Once you've assessed the file, we can discuss on how to create the pivot table
User 02/08/2018 - 02:22
Excelchat Expert 02/08/2018 - 02:28
Already done. Please see attached for your reference. Our source data is in January Sales sheet while our Pivot table is in Pivot output sheet. Once you're able to assess the file, we can then start discussing how the pivot was done.
[Uploaded an Excel file]
Excelchat Expert 02/08/2018 - 02:31
Okay, to create a pivot table same as the one attached, first you need to have the source data selected. You can select just a single cell from the source data, and Excel will automatically select the boundaries for your data.
Excelchat Expert 02/08/2018 - 02:32
In our case, selecting A1 of January sales will do. Next, go to the "Insert" tab of your Excel ribbon and click Pivot table. Notice in the sheet that your whole table was selected automatically even when you initially just selected cell A1. When a window appears, just click OK to create a new worksheet containing your pivot table.
Excelchat Expert 02/08/2018 - 02:33
In that new worksheet, you will notice that you have what you call "PivotTable Fields". Basically, you have your column headers: Salesperson, Products sold and Income generated, as your fields.
Excelchat Expert 02/08/2018 - 02:33
Below this, you'll notice that you have what you call pivot areas, namely Filters, columns, rows and values.
Excelchat Expert 02/08/2018 - 02:34
Basically, the function of the pivot table is to summarize data into an easily understandable method. For now, we wish to know the total products sold and income generated per sales person.
Excelchat Expert 02/08/2018 - 02:34
So if you can see, we first need to know what we want to see prior to trying out the pivot table. In our case, what we wish to see is the total products sold and income generated per sales person.
Excelchat Expert 02/08/2018 - 02:35
To do this, select and drag the "Salesperson" field to the rows. This will create rows per unique entry within the salesperson column in our source data.
Excelchat Expert 02/08/2018 - 02:35
Next, we wish to know the "VALUES" of the total products sold and income generated.
Excelchat Expert 02/08/2018 - 02:36
We can do this by dragging the products sold and income generated to the VALUES area.
Excelchat Expert 02/08/2018 - 02:36
This will automatically provide you with the SUM of products sold and SUM of income generated, which is our objective.
Excelchat Expert 02/08/2018 - 02:37
Depending on your target objective, we may reconfigure the pivot table differently. What we have done is only touching the basics of pivoting, as this subject is in fact broad. However, this basic pivoting actually works wonders for many uses.
Excelchat Expert 02/08/2018 - 02:38
I hope I was of help during this session. Attaching again the sample excel data containing the generated pivot table from a source data set. Thanks and have a nice day! :)
[Uploaded an Excel file]

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc