| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple subtotal rows
I have two criteria by which I want to subtotal - basically I have customer
POs and invoices. The customer can have multiple invoices on the same PO so I want to be able to subtotal the invoice / payment amounts and then subtotal again by PO, showing a total outstanding for each PO. I've been able to do this in the past (subtotal by multiple criteria) and instead of the three tabs at the top left, I get four. However, in doing this today I'm not getting a true subtotal by the PO - still only getting three tabs. I'm on MS Excel 2002 SP3. Thx! mm |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple subtotal rows
I found this article regarding "nested" subtotal difficulties with SP3:
http://support.microsoft.com/?kbid=831824 "smartgal" wrote: I have two criteria by which I want to subtotal - basically I have customer POs and invoices. The customer can have multiple invoices on the same PO so I want to be able to subtotal the invoice / payment amounts and then subtotal again by PO, showing a total outstanding for each PO. I've been able to do this in the past (subtotal by multiple criteria) and instead of the three tabs at the top left, I get four. However, in doing this today I'm not getting a true subtotal by the PO - still only getting three tabs. I'm on MS Excel 2002 SP3. Thx! mm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto subtotal every 100 rows | Excel Discussion (Misc queries) | |||
| Collapsing Subtotal Rows | Excel Discussion (Misc queries) | |||
| Select all subtotal rows on Pivot Table | Excel Worksheet Functions | |||
| Excel - copy subtotal rows only | Excel Discussion (Misc queries) | |||
| using SUBTOTAL() on rows that have been hidden | Excel Worksheet Functions | |||
Linear Mode
