none
Displaying Total in the last row of result set with Sort

    Question

  • Hi Experts,

    I want to display Measures.Amounts with respect to two members of the same dimension like below...

    SELECT [Measures].[AMOUNTS] ON COLUMNS,
           {[Customer].[Group ID].[Group ID].ALLmembers *
           [Customer].[Group Name].[Group Name].ALLmembers} ON ROWS
    FROM [Cube];

    Now, I want to show Total in the last low of the result set as well ORDER BY amount Desc.

    Could you please help in achieving this.

    Thanks in advance.

    --NoorBi

    Tuesday, October 08, 2013 7:24 AM

Answers