Dear all,
I created a room schedule where I sorted the rooms with a custom text project parameter to distinguish the ones that are circulation related and the ones that are not.
In my schedule the rooms are first sorted by department and then they are sorted by "circulation or not".
I would like to calculate for each department the percentage the "circulation" rooms take up compared to the total area of each department.
I thought of using a formula but I am struggling achieving the outcome I want. Could you please assist?
Please see below snipping for clarification. 
