switching layout of Calculated Fields in Pivot Table

I have a pivot table that calculates the number of hours of each type of time. By default excel puts these calculated field (based on fields that the pivot table pulls) as rows for the employee.

I am looking for a way to put these field as columns either directly from the pivot table or a way to convert the data from the pivot table. See screenshots attached. xls1 is what I have, xls2 is what i would like.


Thanks for anyone's help!

Once your table is set up, you can drag fields from the top to the side and vice-versa to switch the layout. It's really hard to explain (for me, anyway), but if you play with it (try dragging the labels for the fields to other spots), you should see how it works pretty quick.

Brigitte

Also another question. I have an IF statement as a calculated field in the pivot table. The formula is: OT Paid =IF('Hours Paid'>40,('Hours Paid'- 40),0). This works great until it calculates the total sum of OT Paid ( Total Sum of OT Paid 6324.5)

What it is doing is taking the total sum of hours worked, sees that it is over 40, and take the sum of total hours - 40. Here are my totals:

Total Sum of Normal Pay -332
Total Sum of OT Paid 6324.5
Total Sum of Vacation Paid 372
Total Sum of Holiday Paid 0
Total Sum of Hours Paid 6364.5

Is there a way to get it to just sum the OT listed for each employee, rather than have it perform the IF statement on the Total for the Sums?