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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub total vs Pivot Table
Jeevan wrote:
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 A problem is you are mixing unit data (total units) with aggregate data (cost per unit). Either Subtotal or PT will aggregate both, which is incorrect for the "cost per" data. I suggest you either import the actual cost, or manufacture it to the side. The latter formula might look like this: Cost = Total Units * Cost per unit Then you can sum/subtotal Total Units and Cost (not cost per unit!), and get a correct (average) cost per unit by dividing the subtotals. |
Reply |
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) |