total KF

Hi

I have data in cube as follows

MatID Amount Quantity

100 80 2

200 40 3

300 40 2

I need to total the KF Amount and quantity. Also I need to find total of amount x quantity for each row.

The final output will be :

MatID Amount Quantity (80x2) (40x3) (40x2)

100 80 2 160

200 40 3 120

300 40 2 80

------------------------------------------------------------------------------

160 7 160 120 80

I request any one to please let me know how to achieve this.

regards

krishna