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
obad62Asked:
Who is Participating?
 
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
 
Deepak LakkadCommented:
Where is product type? (I mean which column?)
0
 
obad62Author Commented:
upper row , PII, POO, PID,  etc..
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
obad62Author Commented:
Yes you can suggest as you like.
0
 
obad62Author Commented:
Dear Admin,

I experian very slow response in EE.

Thank you.
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.

All Courses

From novice to tech pro — start learning today.