Power pivot data relationship

[anshulmarele]

Hi,

All row items (both columns) are repeating when bringing 2 categorical columns from 2 different tables into row field in pivot table through power pivot one-on-many relationship.

How to fix this?

Thanks in advance.

[#2]

@anshulmarele 

Could you please give bit more details or at least screenshot how model is built and what do you pivot.