Hi everyone!

I' have to fact tables
Offer and Offer details. I have a few dimensions, some of them conect to
Offer and some of them to Offer details.
I have two measures, the number of orders (Offer table) and the number of
itmes (Offer details table). The time dimension connects to date column
(DateOfYear) in Order table. I have another date column (DateOfOrder) which
indicates if the offer was fullfield. So, if DateOfOrder is not null, then
the Offer was fullfield.
So, I want to see, how many items were sold and which (Offer details table)
and what was the total amount of this order/orders (Offer table) in some
period. What should I do?
Write a calculated member?! Is so, can you give me a syntax of this MDX
statement?!

Best regards, Uros