Drive table from two different table/ merge two tables.

[dheeraj1688]

hi

I stuck with a problem , i want to drive 1 table from 2 table .OR i can say merge two tables.
getting an error relationship is required .while i already created the relationship.

Dsr table-is main table.
table29 is derived from Dsr table.

i'm creating a summary sheet where i can see dsr and dependencies sheet .

 

[prasaddn]

Hi,

I am not sure if I could get to your requirement. The best I could was to get the required data in one table (PT), but the format is slightly different.
the columns gets split in two rows, Status like Before Time will have sub group of 3 criticalities, Delay will have 3 columns of criticalities and like wise.

Take look at sheet1.

Regards,
Prasad DN.

 

[alacrity59]

My suggestion is a bit crude but has worked for me in several situations.

I've had two tables in two separate sheets. I've created a third sheet that has 5,000 rows that reference the sells in the first sheet followed by 5,000 rows that reference the second sheet. (5,000 rows as the data I was working with had 2,000 rows and I left some room to grow)

To summarize the information I created a pivot table based on the 10,001 rows in this third sheet. (one row for the column headers)

 

[dheeraj1688]

Hi,

I am not sure if I could get to your requirement. The best I could was to get the required data in one table (PT), but the format is slightly different.
the columns gets split in two rows, Status like Before Time will have sub group of 3 criticalities, Delay will have 3 columns of criticalities and like wise.

Take look at sheet1.

Regards,
Prasad DN.

Thank u for reply ..But it won't help as every column split into 3 sub column.
I want to count Dependencies and status. Dsr table act as main table.
So, what i'm trying to create summary pivot table where dsr table will be there and table29 attached to it,when someone click on (+) product milestones list will be shown followed by dependencies column also.
After trying too much and fed up, created separate pivot tables for both.