Pivot table showing totals vertically

J

JBS

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top