I have a 4-level product dimension and for each product I calculate an Average Selling Price (ASP). At the product level I have two types of product: base products and variants. My problem is I need to create a new calculated measure thats gives me the ASP for the base products but associated (lined up) with the variant products. For example:

Product Volume Value ASP New Measure
--------- -------- ------- ------- -----------------
P100 100 350 3.50 3.50
P100A 50 250 5.00 3.50
P100B 60 420 7.00 3.50

I have implemented two member properties at the product level: Product_ID and Base_Product_ID to help resolve this but have not been able to find a solution.
Does anyone have any ideas??

Regards,

JimS