If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Aggregation in hierarchy

Started by hana00, 23 May 2016 04:04:28 AM

Previous topic - Next topic

hana00

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