Hi,
If you need to have a schedule looking exactly like this, it's possible, but it requires a bit of work.
You'll need to add a yes/no project parameter for each floor to rooms. (P1Levele, L1Level, L2Level....) and apply it accordingly to each room.
Then, create a room schedule with Department, Area and all the parameters you've just created.
Now you'll need to add a calculated value for each of the new level parameters - Let's call it P1 (choose Area for type) - if(P1Level,Area,0)
This basically gives you the area only if the room has the P1 parameter applied, otherwise you get 0)
You'll need to add these calculated values for each of the levels.
To get the subtotal, you'll need to another calculated value (again, choose Area for the type) and in the formula P1+L1+L2+L3+L4+L5
The only thing left is to hide the Area and P1Level, L1Level columns.
