How to derive 'Price' and 'Values' from multiple Price Lists

Summary

How to derive 'Price' and 'Values' from multiple Price Lists

Content

We've multiple Price Lists defined in our system. For same Organization/BU, we've different Price Lists defined for different customers. For example: Item price may differ depending upon different customers/countries. But in Demand Management Plans, the Price List marked with Primary only works. How to enable multiple Price Lists? If the limitation is to use only the Primary one, then what is the purpose of allowing multiple Price Lists in plan option.

Any suggestions on custom solutions to handle this requirement? Thank you very-much.

Best regards,

omkar