• Create a set of the two members in a crossjoin and then do a sum on it.

    So something like

    WITH MEMBER [YourCalculation]

    AS

    SUM

    (

    {([Country].[Country].&[India] , [State].[State].&[Andhara])}

    ,

    [Amount]

    )

    Although of course you have provided very little detail so I've had to provide a generic example - in other words don't just copy and paste that code, it won't work. Also it's pretty poor form for you to just ask people to write your code for you 😉


    I'm on LinkedIn