Hi Mikhil, If feasible, consider breaking out Customer from Sales Rep as a separate list. In this case dimensionalizing Customer would allow the data to be rolled up by various data points along Geography hierarchy set (by Customer. Then use an module to assign customers to a sales rep. The added benefit is the easy re-assignment of reps to customers. In addition, as often is the case, reps span regions or geographic territories this approach would make for simpler list management and cleaner reporting. It may also allow the rolling up of other hierarchies to Customer like Products. Recently there were a couple of very good blogs on sparsity and the fact that its ok to NOT combine all hierarchies into 1 list. Model 'naturally'! Give them a read. Truth about Sparsity Pt 1 https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-1/ba-p/44493 Truth about Sparsity Pt 2 https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-2/ba-p/44736 Hopefully this provides a different way to think about the challenge! Regards, Dave
... View more