CUSTOM FIELD OR SUB TOTAL IN PIVOT TABLE

F

FARAZ QURESHI

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table grand total location 1
How do I create a calculated field on the Total in a pivot table? 0
Pivot Table Grand Total Plus Calc Field or GT Running Balance 6
Sub total vs Pivot Table 0
Possible 'calculated field' to total selected pivot table data ite 2
Pivot Table 2007 display field only in Grand Total 0
Excel 2007 - Pivot Table and Calculated fields? 1
How do I perform extended calculations in a Pivot Table in Excel 2 4

Top