View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JBS JBS is offline
external usenet poster
 
Posts: 11
Default Pivot table showing totals vertically

I have data which is 3 columns

Emp no Hours Amount

When I create a pivot table I get the output below

emp no Data Total
536 Sum of hours 111
Sum of amount 4982.36
549 Sum of hours 79
Sum of amount 3336.51
550 Sum of hours 64
Sum of amount 2620.28

What I would like to see instead is

Emp No Hours Amount
536 111 4982.36
549 79 3336.51
550 64 2620.28

Am I just dragging my hours and amount into the wrong area of the pivot
table or is there something else I need to do?