Can you explain how this pivot was made???

When you click on Pivot Table on the right you can see Pivot Table Fields that are used for Rows and Values

Originally Posted by zbor

When you click on Pivot Table on the right you can see Pivot Table Fields that are used for Rows and Values

Yes, my question is... how did she do that? I would like to DO EXACTLY what she did but on another spreadsheet.

Are you asking how to set up a Pivot Table from the first step? If so, here is a web site with and easy to follow tutorial:
http://www.excel-easy.com/data-analy...ot-tables.html

Dont worry - pivot tables are fairly simple to start with, and easy to understand when you go through the creation process systematically. There is a source for the data, which is usually an excel data list. Rows and columns. You click on the list and then go to INSERT - PIVOT TABLE. From there you choose what you want to see in your report.

In your case it looks like the source is some type of EDI database. Do you know the database?

The code you shared is NOT the PivotTable, it is what was written to get the data out of the database for the pivot table. It should be the same each time you create a new pivot report, except that something might change - for instance, the month, date or other part of your data. I would see no problem going to her and asking for a better explanation of the code you shared. It looks like a query to a SQL database - and I am willing to guess she didnt even create that herself, unless she is a systems analyst or data analyst. So there should be no shame in admitting you do not know it.

Anyway, in your workbook, is there another sheet that is the data, more of a rows and columns looking list?

Originally Posted by vicky464

Dont worry - pivot tables are fairly simple to start with, and easy to understand when you go through the creation process systematically. There is a source for the data, which is usually an excel data list. Rows and columns. You click on the list and then go to INSERT - PIVOT TABLE. From there you choose what you want to see in your report.

In your case it looks like the source is some type of EDI database. Do you know the database?

The code you shared is NOT the PivotTable, it is what was written to get the data out of the database for the pivot table. It should be the same each time you create a new pivot report, except that something might change - for instance, the month, date or other part of your data. I would see no problem going to her and asking for a better explanation of the code you shared. It looks like a query to a SQL database - and I am willing to guess she didnt even create that herself, unless she is a systems analyst or data analyst. So there should be no shame in admitting you do not know it.

Anyway, in your workbook, is there another sheet that is the data, more of a rows and columns looking list?

Thank you Vicky464!!!!! I attached the workbook. It has 4 sheets (summary pivot, claims images needed, original data and sheet2)(... the one I screenshot was that last sheet. Unfortunately, I cannot attached the new workbook that I need make look like the one attached because of the sensitive information on it.