MDX question

Hi,

Please help with this MDX.

I need a report with situation of the sales( there are in currency $) and I need to be in EURO.

How could I achieve this?

Thanks,

You can create a calculated member to convert USD to Euro at specified rate (in the example below I assumed $1 = € 0.81) and define its format string accordingly. Like such:

WITH MEMBER [Measures].[SalesInEuro] AS
[Measures].[Sales Amount] * 0.81,
FORMAT_STRING = '€ #,##0.00'
SELECT { [Measures].[Sales Amount], [Measures].[SalesInEuro] } ON 0 FROM Finance