• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot of two sheets having different type of data

N

Neha

New Member
Hi Team,

I have two files having a prodct code ,its plan for a week ,and the factory it is made in .second sheet has customer state and sales per month of dose product code .I want to create a pivot having details of coloumn where it is made how much it is made and whre all it is sold,and how much was it sold.

Can you please help me on this.
 
Hi Neha,

you can do it, if your are using 2003 version, then use the Use Pivot Table Wizard. For 2007/10 use Alt, D, P & follow the Wizard steps.
 
In 2013 Data relationships was introduced and Chandoo posted about it a few days ago

Have a read of:

http://chandoo.org/wp/2013/07/01/introduction-to-excel-2013-data-model-relationships/
 
Hi Srinidhi ,the pivot table wizard has a limitation that data type of both the tables should be same hence ,I am facing some issue.I will paste snapshot of the two files I have

Basepack Distribution Channel Customer State MoC Month Total Tons

19336 GT Haryana 01.2013 0.0832800

19336 GT Haryana 02.2013 0.0691200


file 2 or sheet 2 has data in dese head ,now i want to create a pivot from dis am not able to,if u can tell me ur email id ,I can mail u d files


Basepack Factory Name UOM SC format Location Calendar Week Planning UOM Plant Plant Type Central Plan [RPM]
 
You could use Microsoft Query to join the data. Google it and see what comes up. Also see http://www.exceluser.com/explore/msquery1_1.htm
 
You must log in or register to reply here.
Back
Top