View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RichardSchollar RichardSchollar is offline
external usenet poster
 
Posts: 196
Default How to hide an item subtotal in the row field?

Hi Daniel

Do you mean by right-clicking in the row field, going to Field Settings
and selecting "Non" for subtotals?

Best regards

Richard


Daniel wrote:
To make the appearance of the pivot table report simpler, concise and short,
thereby eliminating repetitive entries, how do I hide an item sub-total on
one of the selected items that was dragged in the row field?