Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I made a pivot table to subtotal sales to multiple customers for multiple
part numbers.The pivot table summarizes by customer and then lists the nultiple part numbers purchase.I want to eliminate the company subtotal line and retain the individual lines for part number sales. also, if possible I'd like to retain the customer name on the remaining lines so it would look like this: customer part qty dollars A b22 3 3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using more than one subtotal with same data set | Excel Worksheet Functions | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Add more lines and more columns in Excel | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Subtotal And Countif | Excel Discussion (Misc queries) |