Subtotal calculation

[Pandurang Rajpurohit]

Hello Team,

Please suggest as to how to achieve the below example subtotal query.
Here there are few parts of different groups , and a report is being
generated which will be shown in the below format.

Now the subtoal is given at the footing line and it has been given
footing at part number which is the sorting key also.
Now again i want to subdivide the part group wise subtotal , please
suggest is this possible in powerhouse.




          Part Number         Part Group        Part Price

                   A 		 123		 		 300
		       A`		 456		 		 400
		       A		 123		 		 100
		       A           456                     400

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

Subtotal :   A                 123                     400
                               456                     800

                   B           123		 		 200
		       B`		 456		 		 100
		       B		 123		 		 100
		       B           456                     400

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

Subtotal :   B                  123                    300
                                457 		       500

(See attached file: Sample calculation.doc)


Thanks & Regards
Pandurang Rajpurohit,
-----------------------------------------------------------------
Project Manager
GM - Powerhouse Tower (DDS)
IBM Global Services India Pvt. Ltd. Pune
Land line : +91 020 40116372
Hand Line : +91 9049009973
EMAIL : pandurang.rajpurohit at in.ibm.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Sample calculation.doc
Type: application/msword
Size: 20480 bytes
Desc: not available
Url : http://lists.sowder.com/pipermail/powerh-l/attachments/20101112/a6208176/attachment-0001.doc