Grouping by values within detail table

[cully651]

I've got a report that's centered around line items. They want it grouped by each category of line items, but the categories are in the same table as the details.

There is a field called "PARENT_YN" to differentiate the detail lines and the category lines... so if "PARENT_YN" = "Y" then that's a category.

I can't bring the table in twice and join it with the criteria set to "PARENT_YN" = "Y" (no data).

Any suggestions?

 

[cully651]

Never mind, it's a flaw in the table design. I knew there was something missing