Matrix with 2 subtotal

Hi All,

I wish to have a report with 2 subtotal using matrix control given by reporting service.

CD

DVD

Total Price

Total Qty

2.00

5.00

JOHN

5

25.00

5

JOLIN

5

10.00

5

Total Price

10.00

25.00

Total Qty

5

5

I only can came out total price(subtotal) which provided by matrix control.

Does the matrix control able to come out as table above with 2 subtotal?

Thanks

Kendy

The grid above has the unit price in the header and only the quantity measure in the details area. You need to create and additional Price measure and display both measures in the details area either on the rows or the columns as a static group. E.g.

Measures on Columns

CD

DVD

Total

2.00

5.00

Quantity

Price

Quantity

Price

Quantity

Price

JOHN

5

25

5

25

JOLIN

5

10

5

10

Total

5

10

5

25

10

35

Measures on Rows

CD

DVD

Total

2.00

5.00

JOHN

Quantity

5

5

Price

25

25

JOLIN

Quantity

5

5

Price

10

10

Total

Quantity

5

5

10

Price

10

25

35

|||

Thanks for your helps and advice.

Its really give me an ideas

Thanks Adam