View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dianeha
 
Posts: n/a
Default Removing a subtotal from an insert item in a pivot table

I want to insert in a new item from the list on a pivot table that currently
has subtotals in it. Every time I drag and drop the field name in it
automatically subtotals the new item. I do not want the subtotal in the
newly inserted field item. How can I remove the subtotal and keep the pivot
table intact?