Relationships Help

[vnazor]

Hi, The data I am using is grouped by MHC then Arrival Dates. The relationship makes the MHC line up on the report table but when I add the relationship (arrival dates) it doesn't fix the grouping. I've tried a number of ways but can't seems to get it lined up. Can anyone assist? Thank you

[vnazor]

I duplicated columns MHC & Date then merged together for each query so, the new column would have the relationship which containes both the MHC & Date. 

[xZLeni127]

Finally someone has the question I wanted to ask right now.. thank you for the solution you found. I will try it..

[vnazor · Accepted solution]

I figured it out. 

[V-yubandi-msft]

Hi @vnazor ,

Thanks for the update. If possible, please consider sharing the solution in the community it could help others who are facing a similar issue.

Best regards,
Yugandhar.