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?
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?