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

    Lightbulb Unanswered: MDX for Percentage on row or column totals


    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

    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