I am in need of a solution similar to the lookup()script function, but for charts. Pretty much like Excel VLookup.
I have a Sales Fact table and two dimension tables, Customers and Products.
I also have a special pricing table for customers on each product. I want to be able to display the special price for each product by customer, obviously also against sales and other measures.
I have tried using (Only) but this doesn't work unless only one product and customer is selected. I also though of doing an ApplyMap() on the Fact table creating a key from Customer&Product Codes. But this loses the visibility on special pricing for products that has never been sold for that customer.