Maybe like attached, using a pivot table in indent mode.
Or look into something like described here:
Missed that you are using PE, so here is what I did:
LOAD * INLINE [
Product Group, Product, Description
Kitchen, Spoon, Steel
Kitchen, Cooker, Hot
Kitchen, Plate, Steel
Kitchen, Knife, Sharp
Gadgets, Mouse, Tiny
Gadgets, Keyboard, Keys
Gadgets, Monitor, Large
to load some sample data.
Then create a pivot table with dimensions, Product Group and Product.
Use indent mode on style tab and 'subtotals on top' on presentation tab.
comm97114.qvw 134.5 K