Solved

How to make this data into a pivot table

Posted on 2013-01-09
6
155 Views
Last Modified: 2013-01-19
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
Comment
Question by:obad62
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:Deepak Lakkad
ID: 38758640
Where is product type? (I mean which column?)
0
 

Author Comment

by:obad62
ID: 38777177
upper row , PII, POO, PID,  etc..
0
 
LVL 11

Expert Comment

by:Deepak Lakkad
ID: 38777707
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
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 

Author Comment

by:obad62
ID: 38781563
Yes you can suggest as you like.
0
 

Author Comment

by:obad62
ID: 38786645
Dear Admin,

I experian very slow response in EE.

Thank you.
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 38786682
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

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question