Issue in ABAP CDS Views - SAP S/4 Hana Public Edition

Hi SAP Experts!!

I person created a Data explanation with Sales Order and Sales Order Item fields and erstwhile I spot the output I americium getting arsenic below.

But My request is to get information arsenic below. 

I necessitate bid items grouped with bid no. 

Kindly Help.

Thanks,

Sai Bhargav