Pivot Table Question

[srizki]

In my pivot table, I want non-productive hours and total hours side by side in the same row. The problem is that non-productive hours are showing as count of non-productive and not as sum of non-productive, unless I put them in DATA field with total hours that creates two lines item. When I put it row field, the option to change it to sum is grayed out and if it is in DATA field I can change it to sum in pivot table setting.

Any suggestions.

Thanks

 

[gehusi]

Drag and drop your data field onto the word total. Then they will display across the row.

 

[srizki]

Thanks Gehusi