How to calculated a aggregate value of current member in hierarchy? City = value of all buildings, building is equal to value of all storeys and so one.
Node name data added manually calculation
City 60 70
Building 1 40 70
Storey 1 20 20
Room1a 20 20
Storey 2 50 50
Room2a 30 30
Room2b 20 20