• 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.

creating a pivot table from two separate sheet

I use Excel 2013.Yes,Power Pivot is present there.I could not able to establish the relationship over there.

Can you kindly guide in this case as above mentioned are sample data only.In reality there are more than 4000 rows in each sheet.
 
paradise said:
Dear Sir,

I am still waiting for your reply.
Click to expand...

Sorry for the delay, but I find I do my best work when I get to sleep at night ;)

OK -
I linked both tables to PowerPivot
I've created a relationship between the two tables for you by creating a Unique Key. There's not a lot of data here, so I'm not sure you're going to see much happening ... Where does the data for SO and DO originally come from? If they are in external databases, you can link to them directly without bringing them in as tables.
 
The data actually comes by exporting from a software in a csv format.I just simply import those data into excel.Those mentioned is simply a sample one.In reality I have a lot more than 4000 which I cannot disclose as it is private of someone.

My work is to make reports by combining those two worksheet into a Pivot table by matching based on condition.

I love using Pivot Table and I think Power Pivot is much more nice for creating Pivot table.But the problem is of establishing relationship which u told earlier.

Can you let me know the entire process of making in Power Pivot esp.creating a unique.

Pls send me the file with steps.I will be eagerly waiting for your kind help.
 
Last edited:
As I had thought, the data is from an external source. You can link the external tables into PowerPivot, create unique keys in each table and and relate them. From there you can produce a pivot table report from the related tables.
 
Kindly send me the file which I have uploaded in above post after making and creating relationship that you have created.I want to see how u have done.As I don't know how to create a unique key.After looking the sample which I have posted will try in my large data.

I will be eagerly waiting for your kind help.
 
I am having trouble uploading a file - this has happened a few times of late .... I may have to shut down and start again
 

Attachments

  • test multi pt - DME.xlsx
    382.4 KB · Views: 5
I think I could not get it.I have created two pivot table (my original workbook) and would like to merged into one pivot table.Kindly see the attachment.As stated highlighted is matching criteria.

In addition to it,I have uploaded the by making pivot table in workbook sent by you.The Qty highlighted in Red (DO sheet Qty) seems to be wrong as it is not a perfect match and data is not pulled properly in pivot table.

Hopefully,you will sort out this issue.
 

Attachments

  • test multi pt.xlsx
    78.1 KB · Views: 1
  • test multi pt - DME 1.xlsx
    387.2 KB · Views: 0
Last edited:
You must log in or register to reply here.
Back
Top