Hi
I am a banker and I want to generate a summary showing the total balances of
outstanding advances/loans of each segment i.e. Business Loan, Housing
Finance Scheme, Lease A and Business Lease B.
How can I have a pivot table designed to show total of each product with but
Auto Lease and Business Lease should also be showing a subtotal type of field
of both the Lease products. Example:

Branch Housing Business Lease-A Lease-B Grand-Total

Thanking you all,

FARAZ!