• 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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