Sum metrics

[pabcig]

Hi everyone!!

I´m new with mdx. I need to get the result show in attached filed mdx2.jpg. To understand a bit more I attached mdx1.jpg

To get the result a wrote this mdx:

WITH MEMBER [Entidades].[Entidad].Total as
'[Entidades].[Entidad].[HSBC BANK ARGENTINA S.A.]'
MEMBER [Entidades].[Entidad].Total2 as
'[Entidades].[Entidad].[CITIBANK N.A.]'
MEMBER [Entidades].[Entidad].Total3 as
'[Entidades].[Entidad].[BANCO DE TUCUMAN S.A.]'
MEMBER [Entidades].[Entidad].Totales as
'[Entidades].[Entidad].Total + [Entidades].[Entidad].Total2 + [Entidades].[Entidad].Total3'
Select
{[Entidades].[Entidad].Totales} on 0
from nosis
where [Measures].[I CUIT]

But this return 36, not 35. What I doing wrong?

Thanks!
Pablo

[pabcig]

I solved the problem in that way:

Select
{[Measures].[FC CUIT Count]} on 0
from nosis
where ({[Entidades].[Entidad].[HSBC BANK ARGENTINA S.A.], [Entidades].[Entidad].[CITIBANK N.A.]})