you can create something similar using Pivot table.
First you need a extra grouping table:
Room Type, Room Group
6 Bed Mixed Dorm, Dorms
8 Bed Mixed Dorm, Dorms
Standard Rooms, Private rooms
Deluxe Rooms, Private rooms
Luxury Rooms, Private rooms
Designer Suites, Private rooms
And then create a Pivot table chart with the Room Group as dimension.
You can then enable Show partial sums (in Presentation tab) on the dimension level below the group.
The result looks like this, first 4 columns are dimensions, last 3 are expressions.
If you need a full table looking exactly like the one you have, that would be more complicated - using aggr().