Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    Berlin
    Posts
    72

    Unanswered: Percentage measure

    Hi,

    easy question for advanced users:

    I have a dimension called "Movement rate". The members are "1" to "6".
    There is a measure called "No. of Products".

    What i easily like to do is showing the percentages "No. of Product" for each "Movement rate" of the amount of "No. of Products" without using the frontend-tool.

    Thx in advance for any help.

    Andreas

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    What is your table layout?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2002
    Location
    Berlin
    Posts
    72

    Table layout

    Just for ur further explanation:

    I like to get the following (red) result:

    Movement rate No. of Products No. of Products in %
    1 100 10
    2 100 10
    3 200 20
    4 300 30
    5 200 20
    6 100 10
    Amount: 1000 100

    My table design is the following:

    "Movement rate" int
    "No of Products" int


    I don't know for what reason u need this table design, cause what I need is the MDX - Query for my cube.

    Thx.

Posting Permissions

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