| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CUSTOM FIELD OR SUB TOTAL IN PIVOT TABLE
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a total field for a pivot table/pivotchart | Excel Discussion (Misc queries) | |||
| Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
| Using '% of Total' in calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table - Custom Row Field | Excel Worksheet Functions | |||
| Pivot Table Calculated Field (Grand total question) | Excel Discussion (Misc queries) | |||
Linear Mode
