Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2002
    Location
    Malaysia (KL)
    Posts
    9

    Lightbulb Unanswered: MDX for Percentage on row or column totals



    Hi,

    Can anyone give me a solution for the foll:

    My MDX query is something like this:

    SELECT {[Customer].Levels(1).members } ON COLUMNS,
    {[PERIOD].Levels(1).members } ON ROWS
    FROM [LOAN]

    the customer dimension levels(1) is the state names so the result displays all the loan values for all the states for the year 1999,2000,2001.

    How can i transform the cell values into Percentage on either row total or
    percentage on column total.

    I know we have to use calculated cells but what would be the syntax for the above MDX.Please help.

    Any Ideas?
    Last edited by cddeepak; 02-27-02 at 23:18.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •