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.

AndreasWhat is your 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.