| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub total vs Pivot Table
If the following is my data, Can I use a Pivot table to get a subtotal for
units and a single cost? If I use Sub total, costs also get subtotal which is incorrect? Thanks Style Total Units Cost per unit 220995 -3 13.1 220995 -1 13.1 220995 -1 13.1 220995 -1 13.1 220995 3 13.1 220995 -1 13.1 240995 -7 13.1 240995 -1 13.1 240995 -1 13.1 240995 -1 13.1 240995 4 13.1 250995 -168 7.05 290995 -1 25.2 290995 -1 25.2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
| Pivot Table Row Total | Excel Discussion (Misc queries) | |||
| Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
| Sub Total In Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
