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?

Pivot table showing totals vertically
 

emp no Data Total
536 Sum of hours 111
Sum of amount 4982.36
etc

In the pivot, just drag "Data" and drop over "Total",
and it should return the desired results:

Emp No Hours Amount
536 111 4982.36
etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---
"JBS" wrote:
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?

Pivot table showing totals vertically
 

Take a look at Debra Dalgleish's video:
http://contextures.com/xlVideo001.html

JBS wrote:

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?

--

Dave Peterson

Pivot table showing totals vertically
 

You guys are fantastic. You have just saved me hours of work. Thanks