Hi @Giridhar.Prabhu,
Transforming the Booked Channel field into a new field that only shows individual channels isn’t exactly possible but a work-around you could use is to setup a denseRank calculation, partitioned by channel, and filter down to 1 row per channel type (just rank 1s).
Then you could use LAC-W calculations, like sumOver, to retrieve your values for the Booked and Reported fields. Once again partitioning those fields by the booked channel field to ensure they are grouped appropriately.