5 Replies Latest reply on Jul 28, 2016 8:09 PM by Freddy Setiawan

    Problem grouping in MDX cube

    priyanka reddy

      Hello,

      I am connecting to a MSAS (Cube).

      I created following calculated Member called

      Cultural = [DMA].[NEW YORK]+[DMA].[PHILADELPHIA]+[DMA].[WASHINGTON DC (HAGRSTWN)]

       

       

      For the week of 1/3/2016 - 1/9/2016 when we add these 3 cities the total should be 40,704, but I get a different total ( 31,691) as you can see in the screenshot below.

       

      I am not sure what mistake I am doing, Kindly let me know what mistake I am doing.