Parent-Child Sales Aggregation Issue

Hi Team,

 

Lets say we have sales at parent level in base dataset1 and same is assigned to the corresponding children in dataset2. The total sales should remain 60 even when displayed at child level but Pyramid aggregates the sales for each row and shows 120.

Is there a workaround/steps to maintain the aggregation grand total at parent level even when we have both Parent and child on the same grid visual?

 

DataSet1

Parent	Sales
A	10
B	20
C	30

 

Dataset 2

Parent	Child	Sales
A	1	10
A	2	10
B	3	20
B	4	20
C	5	30
C	6	30