View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Suzanne Suzanne is offline
external usenet poster
 
Posts: 152
Default Pivot Table - Hide Total Row without hidding corresponding row

I have a pivot table with several rows, one of which is 'Cycle Time'. I want
to show this row for each of the items in the table, but don't want it to
appear as a total. When i try to hide it, the corresponding rows (of detail)
in the table hide also. I want to see the rows in the table, but not in the
totals. Any ideas please?