Driver based allocation on conditional basis

Summary:

Scenario is driver based allocation between entities where driver is revenue. Challenge is where different set of revenue total should be considered for allocation based on cost center. Below example may give more clarification.

Content (required):

Consider entities US, Canada, Japan and cost centers CC1 and CC2.

Table 1 defines allocation keys based on region where revenue total is considered per allocation region.

Table 2 defines mapping between cost center and allocation key

Table 3 defines allocation based on cost centers and you can see for same entity, instead of applying single percentage on total revenue, different percentages are applied based on cost centers.