Sorry this is driving me mad, I think I am just stupid!!

I have a fact table(Sales) with a set of product sales, giving product
number (PLU), quanity(Quantity) etc. The product price is however in
another table, the products table(Products), this also has the product
number(PLU ) and the unit price (Price).

I am trying to show the total price(Total), i.e. Price x Quantity but can't
work out how to set this up as a calcualte member.

Please help and put me out of my misery!

Best solution I've found is to create a fact table view where Total Price is calculated in SQL and then map it to a standard measure
HTH
Bria
www.geocities.com/brianaltmann/olap.html

Brian,

thanks for that, i'll give it a go, i am much more comfortable with sql than
mdx!

Regards

mark
"Brian Altmann" <anonymous (AT) discussions (DOT) microsoft.com> wrote