We have a new request from our sales ops to consolidate some plans. The ask is to consolodate two different sales titles, each from a different territory, each with a different quota component. The territories quotas are calculated differently however, but for the new consolidated sales title it will have the same quota component. Does anyone have this as their territory and quota plan and can give any insight?
Can I assume that the two sales titles exist with two different hierarchies?
If not, then the two sales title should be able to logically roll up into the parent.
If this is not the case is it possible to create a parent and assign them via the general lists making sure to provide a top level summary.
If it is not straightforward to allocate a parent then create a separate consolidated list. Create two mapping modules using each of the sales title lists and a list.formatted line item using the new consolidated list. Map each item in the two sales title lists to the consolidated list and used the two mapping modules to aggregate the data into a new consolidated module.
Use a combination of SUM to aggregate the data.
Something like Sales Data.Sales List 1[SUM:Consolidated Mapping List 1.Line Item] + Sales Data.Sales List 2[SUM:Consolidated Mapping List 2.Line Item]
The line item must be formated as a the consolidated list.
In any case a relationship needs to be established between the individual sales lists and a consolidated list.
This can be achieved either by incorporating them into a hierarchy or via a manual mapping table with each module dimensioned by the individual sales titles and a line item formatted as the consolidated list member.
Both options involve creating a new list either as the parent of the sales titles or as a flat list holding the name of each consolidation.
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA