How can I group items that fall under the same list?

[neena123]

Below is a bundle that has been broken out. Unfortunately, if a bundle is not broken out you cannot see the item of the individual items under that bundle. The first picture is what I have currently in my report. How can I make it into the second picture?

Is there a way I can transform the data into this below:

[isingh30]

Sort Line Number in ascending order.You can hide related line no column as well. What table is it?

Thank you!

[neena123]

Thanks for the reply! But that wouldn't work since the  Line number can be reused. To make it unique I would have to use the Order Number and Invoice number. I guess my example wasn't very clear. 

[isingh30]

Can you share your data or app?

Thank you!

[vamsee]

Hello Neena,

According to what I have interpreted your data to be, the logic would be

Transform:

NoConcatenate

LOAD Distinct

Item,

NUM([Line Number]) as [Line Number],

//[Related Line Number],

Price

Resident Input;

Left Join(Transform)

LOAD Distinct

Item,

NUM([Related Line Number]) as [Line Number],

Price

Resident Input;

DROP Table Input;

Please find the attach qvw for the same. Please provide more data if this doesn't suite your need.

Thanks

Vamsee

[neena123]

Hi Ishtdeep, Sorry I can't share my qvw but I have attached a sample of data. You can see that there are the same line number used over again and to make it unique is the order number. Anything with a 0 means it is the Parent/Bundle. It also won't always say Bundle it can have any name but what will always stay the same is a 0 value for the invoice number.

[Qrishna]

Hi Neena,

Make sure you follow the proper sorting of the numeric fields.check out the attached.