View Single Post
  #1   Report Post  
leo
 
Posts: n/a
Default How do I remove the individual subtotal lines from a pivot table..

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