Report to include the parent OU infront of the user

Hi,

 

I have the following scenario

 

domain\OU1\newOU has user1, user2 and user3

 

Domain\Ou2\customOU has user4, user5 and user6

Now I need a report that shows something like this

User         OU

User1        OU1

user2         OU1  

user5         OU2

user6         OU2

user3         OU1

 

I tried doing this but it shows the CustomOU and NewOU infront of the users.

Appreciate your help