Associating a list to a hierarchy
I created a Cost Centers list with values (1, 2, 3, 4, etc.) and a hierarchy of Business Unit lists (Business Unit 1, Business Unit 2, Business Unit 3). I'm looking for a way to associate each group of cost centers from the Cost Centers list to the Business Unit hierarchy. The hierarchy Business Units 1-3 values together will uniquely define what cost centers are associated with the parent-children.
I created a systems module that associates each Cost Center value to the combination of Business Unit 1-3 hierarchy values. Is there a way to create an association so that if you drill down on a Business Unit 1, 2 and 3 in a module, you will be able to see the cost centers that fall under it? Below is an example:
|Business Unit 1||Business Unit 2||Business Unit 3||Cost Center|
|Corporate||Planning & Development||Process Analytics||1|
|US||Planning & Development||Process Analytics||3|