PowerPivot: Reports using parent and child tables

[manzoo79]

Hi,
Have a parent table with following Data.

ChildName	ChildName
1	Parent1
2	Parent2

<tbody>
</tbody>

Child table with following data. ParentID(FK) is referenced to the above table.

ChildID	ChildName	ParentID
1	Child 1	1
2	Child 2	1

<tbody>
</tbody>

Both the above tables are in SQL Server.
I would like to create a report having Parent Name and the child names in a grid like the one below.

Name	ChildName
Parent1	Child 1
Parent1	Child 2
Parent2	Child 3
Parent2	Child 4

<tbody>
</tbody>

I imported both the values using the power pivot wizard and then created a flattened power pivot and pulled in Name from Parent Table to Rows fields and then dragged ChildName column from Child table on to the Rows Field.
But I am getting a report where the data is duplicated irrespective of the foreign key constraint.

Name	ChildName
Parent1	Child 1
Parent1	Child 2
Parent1	Child 3
Parent1	Child 4
Parent2	Child 1
Parent2	Child 2
Parent2	Child 3
Parent2	Child 4

<tbody>
[TD="colspan: 2"]Parent1 Total
[/TD]

[TD="colspan: 2"]Parent2 Total
[/TD]

</tbody>

Can you please suggest me how to handle this?
Thanks and Regards,
Manjunath

 

[miguel.escobar]

I'm pretty sure this post from Alberto will help you:
Alberto Ferrari : Tabular Parent/Child Dimensions: SumOfLeaves and the CALCULATE wall