View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default pivot table format

When I create a pivot table with two fields as row groupings (e.g., state and
county) the state is included in the output only when there's a change in the
state value. Also, there's a subtotal for each state. I want the state to
be on every row and I don't want subtotals. By the way...I'm using Excel
2003.