In order to use hierarchies you need to use both the
hierarchy load statetement (if your input is child, parent), or use your already existing adjacent nodes table.
hierarchy belongs to statement. (with this table you can "attach" something to a node you like, e.g. make a flag for a country, so all its cities also get this attribute associated)
PS: the hierarchy load statement creates new fields for you (costcenter1, costcenter2, costcenter3), you should use the numbered costcenters in your pivot table in order to have correct summarization.
PS2: look very well at the new fields that are created by these statements. You will also have to drop fields to remove synthetic keys. Normally just keep the real key like costcenter_key. In the beginning just use real good fieldnames like "belongs_to_parent", belongs_to_nodename