Still very new with FM... More just checking if this is possible before diving into lots of reading, etc.
See attached image... I hope my question is clear from the image.
Nope. Not clear.
It would help to label the entities in your relationship graph.
What you describe looks possible if you set up a summary report based on the 2ne table occurrence from the left.
The Blue "style" report object would be a sub summary part "when sorted by style". The items would be shown in the body using one row portals set up to produce what we call a "horizontal portal". Note that the maximum number of items that you can show would be fixed.
It looks like accordion UI, don't you want hiding whole rows if right edge red angle is "closed" ?
Retrieving data ...