Hi Giridhar @Giridhar.Prabhu ,
You said you have two columns in the first sentence and later on said that booked channel and reported channel can be different in the same row. So, I’m a bit confused here.
Please create a sample in Arena to allow other community members to take a shot at helping you.
Regards,
Arun Santhosh
Pr QuickSight SA