• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

How to make this data into a pivot table

Hi Experts,

Please find attached excel sheet, I need to make a Pivot Table by product type.

thanks,
Customer-Report-By-Deal-Type.xlsx
0
obad62
Asked:
obad62
  • 3
  • 2
1 Solution
 
Deepak LakkadCommented:
Where is product type? (I mean which column?)
0
 
obad62Author Commented:
upper row , PII, POO, PID,  etc..
0
 
Deepak LakkadCommented:
Hi,

To create pivot table, your data should in be proper format.

In your attached excel file - Data is not in proper format.

If you can give what result do you want to achieve, i can suggest changes in the data accordingly.

- Deepak Lakkad
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
obad62Author Commented:
Yes you can suggest as you like.
0
 
obad62Author Commented:
Dear Admin,

I experian very slow response in EE.

Thank you.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
obad62,

   to get "Admin" attention, you would need to use the "Request Attention" link on this page.
 
  anyhow, what was posted above is this:
  your excel sheet, as it is, cannot be used to create a pivot table directly.

  you would need to make the PII, PID, PIF a value in a column, and hence "duplicate" all the rows ...
  let me attach the file to show you what I mean, I started the transformation for a couple of "product types" ...  you have to finish it ...

  from that part you should be able to do the pivot table as needed.

hope this helps
Copy-of-Customer-Report-By-Deal-.xlsx
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now