Fetching values from an entity with indirect relationship

[subhashis29]

There are 6 entities- A, B, C, D, E, F
Relationship are defined in the diagram.

There are values in table F Which I need to show for the records of Entity 'A' but segregating the values on the values of Table E

but when I am taking the values from entity F, in the matrix chart it is showing same values for all the Entity 'E' records, the calculations are not getting segregated on the basis of Entity 'E' records.

I need to show values from Entity 'F' segregated on the basis of Entity 'E' records.

Any suggestions/solutions for this?

[amitchandak]

@subhashis29 , Change join D-E , also one to Many, E on Many side