none
How to get add 8 ,10 in the following mdx query RRS feed

  • Question

  • Hi experts ,

    i want to get the sum value of 8,9,10 , how to change my mdx query .

    WITH MEMBER [Measures].[name] AS (  ([Measures].[name1],[name2].[name3].&[9])),Format_String='#,##0.0000;-#,##0.0000'SELECT NON EMPTY { [Measures].[name] } ON COLUMNS  FROM ( SELECT ( [日期].[月层次结构].[日期].&[20190101] : [日期].[月层次结构].[日期].&[20191231]) ON COLUMNS  FROM Hospital_IP )

    Thanks in advance


    Tuesday, May 26, 2020 5:27 AM

Answers

  • Did you mean create sum calculation?  You could add them directly, see if follow works:

    WITH MEMBER [Measures].[name] AS (  ([Measures].[name1],[name2].[name3].&[8])+([Measures].[name1],[name2].[name3].&[9])+([Measures].[name1],[name2].[name3].&[10])),Format_String='#,##0.0000;-#,##0.0000'SELECT NON EMPTY { [Measures].[name] } ON COLUMNS  FROM ( SELECT ( [日期].[月层次结构].[日期].&[20190101] : [日期].[月层次结构].[日期].&[20191231]) ON COLUMNS  FROM Hospital_IP )


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by mitaraiqueen Tuesday, May 26, 2020 5:51 AM
    Tuesday, May 26, 2020 5:31 AM