STUMPER: Pre-solved Q&A to sharpen your TBM and Apptio skills.

Solution posted in 7 days if nobody submits a correct answer.

See title for rating: [+] Easy   [++] Moderate   [+++] Challenging

I have a data table which helps me map Cost Source object to Other Cost Pools object in my Cost model.

It maps one cost center to one or more IT resource towers (and sub-towers).

Here's an excerpt:

For example, cost center 210 is being mapped to three sub-towers within the Application tower.

This mapping happens as Cost flows between the two objects, as seen here:

My data table from the first screenshot backs the Other Cost Pools object.

I validated several examples and everything works fine so far.

Cost center 210 for instance is being split evenly across the three Application-related sub-towers seen in the table.

After further thought and analyzing past trends though, I want to change this model allocation to accommodate uneven splits per sub-tower.

For instance, cost center 210 should actually be a 40/40/20 split across the three applicable sub-towers.

How can I set up uneven splits within this allocation?

@Chris Davidson,

if you have the % Allocation Percentage that each Cost Center (i.e. 210) breaks down into you can append the column with that information to Other Cost Pools Master data set (i.e. Cost Source to IT Resource Towers).  Then you would need to change you weighting instead of even to % Allocation or % Planned Allocation if you were in the Cost or Budget Model.

Your solution worked nicely, thanks.

Here's the result: