Percent of Product Sales on Produt Line using cube as a datasource.

[pricter]

Hi all,

I would like to compute the percetage of product sales against the product lines sales based on a cube package.
For Example if we have the Product Line A with sales 100 and the Products A (20 Sales), B ( 30 Sales), C (50 Sales)
and the Product Line B with sales 50 and the Products D (25 Sales) and E (25 Sales)
I would like to produce the following crosstab:

              Line Share
A                   20 %
B                   30 %
C                   50 %
D                   25%
E                   25%

Could someone help me how could I achieve that.

[paddhu]

Use the Member summary function percentage([dataitem] within [set]).